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

Reply via email to