SQLite Forum

Operation speed
Login
Ooops.  Maybe I have that backwards.  Anyway, the creation of the missing index is the first step.  Then EXPLAIN QUERY PLAN and/or .eqp on are your best friend.