[sqlite] newbie question re indexes

[Andy Turk]

I'm very new to sqlite and have a question about indexing: are indexes
used when doing range searches on integer columns?

Suppose I have a table and index like the following:

CREATE TABLE example (value INT);
CREATE INDEX example_value_idx ON example (value);

If I issue the following query, is sqlite going to narrow the search
with the index, or scan the whole table?

SELECT * FROM example WHERE value >= 5 AND value < 100;