SQLite Forum

Usage of suboptimum index
Login
Here's a thought:  Have you run ANALYZE recently?  Are you sure the stat1
data is current?  Please run ANALYZE again before you send us the output
of the ".fullschema" command.