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

Reply via email to