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=?)