On 1 Oct 2019, at 8:15pm, Fredrik Larsen <frel...@gmail.com> wrote: > I have run analyze on production data, that should work better, right?
Yes, that is the best way to do it. I've been given some databases where the data saved by ANALYZE shows it was run with empty tables. So I sometimes warn people that this does not give the right results. Glad to see that you got the behaviour you want using INDEXED BY. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users