SQLite Forum

Usage of suboptimum index
Login
You can force SQLite to use whatever index you want using the INDEXED BY clause
on the query.  This is not recommended in production, but is useful for
debugging and analysis.

So, have you tried your query using each of the various indexes to see which
version runs fastest?