> are indexes used when doing range searches on integer columns? Yes, your simple example will use the index, but it has nothing to do with the data being integers. You can read all about indices at
http://www.sqlite.org/php2004/page-041.html and following pages. You can see whether a query is using indices with the explain feature of the Sqlite shell. Regards
