On 4 Nov 2017, at 12:34am, Deon Brewis <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
