SQLite Forum

Defragment a table ?
Login
So you have an index on the "other column" in table A?  So something like:

```
create table A
(
   id integer primary key,
   oc integer
);
create index idxA on A(oc);
```

is index idxA unique?