Before running a query, SQLite decides how to run it: read every row, or jump through an index. EXPLAIN QUERY PLAN shows you that decision, and one word of its output tells you whether a query will stay fast as the table grows.