The "lite" refers to things like:
- it only has b*-tree indexes
- it only has one index per-table source - it only has b*-tree indexes
- it only has one index per-table sourceI don't know for sure what this means, but it sounds like it is incorrect.
SQLite tries to only uses indexes in situations where they help the query run faster. SQLite is not limited in its use of indexes. It is just that the use of multiple indexes for a single FROM-clause term is rarely helpful.