On 4 Nov 2017, at 12:34am, Deon Brewis <de...@outlook.com> wrote:
> I have a query that joins with a virtual table where the optimizer has a > choice of picking between 2 indexes for something, and it picks by far the > wrong one. Execute the SQL command ANALYZE. You can add this to your app temporarily, or use the SQLite command-line tool. Then try everything again. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users