[sqlite] Why is SQLite refusing to use available indexes when adding a JOIN?

Why is SQLite refusing to use available indexes when adding a JOIN? The queries to create the database is: CREATE TABLE foo(id TEXT); CREATE INDEX `foo.index` ON foo(id); CREATE TABLE bar(id TEXT); CREATE INDEX `bar.index` ON bar(id); CREATE VIEW baz AS SELECT id FROM foo UNION ALL SELECT id FROM

[sqlite] Why does SQLite refuse to use available indexes when adding a JOIN?

ally flatten the query (because I do not know a priori which databases will be attached). Therefore, is there any way that I can write a query onto this view that will join another table and still be able to use available indexes? Thank you for your time, Ofer Sadgat ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users