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