SQLite Forum

Usage of suboptimum index
Login
Quite so. The heuristic is only used if, as in this case, both indexes are either covering or non-covering. More completely:

[](http://www.sqlite.org/src/artifact/2ea911238674e?ln=1956-1960)