On 15 Feb 2018, at 11:31pm, David Pitchford <david.t.pitchf...@gmail.com> wrote:
> So I'm wondering not just for this query, but in general, how can adding an > index cause a query plan to change even if the new query plan doesn't make > use of the new index? After creating indexes and entering plausible data (in any order) use the command "ANALYZE". This allows SQLite to pick the best query plans. Having done "ANALYZE" once you do not have to do it again unless you've changed your schema. The results are stored in the database file. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
