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?