I have run analyze on production data, that should work better, right? Or do you propose to "trick" the query-planner using some kind of staging-data?
Anyway, I use INDEXED BY hints now, and this solves my problem. Fredrik On Tue, Oct 1, 2019 at 8:57 PM Simon Slavin <slav...@bigfraud.org> wrote: > When trying to make SQLite pick the right index, please use this sequence. > > 1) Create your indexes. > 2) Put typical example data in your table. > 3) Use the ANALYZE command > 4) Delete the test data and put in real data (optional) > > You can do (1) and (2) in any order. But having data in the table makes a > difference, and leads to better results than doing ANALYZE with empty > tables. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
