Hello,
I tried really hard to get partial indexes working, but SQLite refuses to
use them:
> create table "t" ("id" INTEGER NOT NULL PRIMARY KEY, "flags" INTEGER,
"uniqueId", "syncFolder" INTEGER);
> create index "i1" on "t" ("id") where "uniqueId" IS NULL;
> explain query plan select * from "t" where "uniqueId" IS NULL;
0|0|0|SCAN TABLE t
> explain query plan select * from "t" indexed by "i1" where "uniqueId" IS
NULL;
Error: no query solution
Any advice what am I doing wrong?
Thanks,
Filip
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
