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.

sqlite-users mailing list

Reply via email to