SQLite Forum

What indexes help Window Functions
I don't think it's quite true that "a query can use zero or one index". That would be true for a simple projection query, selecting from a single table. But in general subqueries and joins will involve multiple tables and possibly as many indexes as table usages.

Looking at query plans will help you decide what indexes may help and do help.