How does the performance compare with this: CREATE TABLE t1 (a TEXT, b TEXT); CREATE TABLE t2 (a TEXT, b TEXT); CREATE INDEX t1_a ON t1 (a,b); CREATE INDEX t2_a ON t2 (a,b);
SELECT * FROM t1 LEFT JOIN t2 ON (t1.b=t2.b AND t2.a='123') WHERE t1.a='123'; On 1/5/20, Peter Inglesby <peter.ingle...@gmail.com> wrote: > Is there any more information I could provide? Run "ANALYZE;" on a database that contains actual data, then send us the output of ".fullschema" -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users