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

Reply via email to