eg:
CREATE TABLE Person (id integer primary key, name text, age integer default 5);
CREATE INDEX index_age on Person (age);
EXPLAIN QUERY PLAN select * from Person where age = 9;
selectid order from detail
---------- ---------- ---------- -------------------------------------------------
0 0 0 SEARCH TABLE Person USING INDEX index_age (age=?)