Hi Cory,
Regarding:
Is there a reason [the sql command] BETWEEN can't use [an index]?
Hmm... nobody has an answer? Or did my message get eaten by a spam filter
:(
I can't answer your question by providing you the reason, but it appears to
be a fact that you will want to use separate comparisons and avoid BETWEEN
if you wish an index to be used, see:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg05030.html
Donald Griggs
Opinions are not necessarily those of Misys Healthcare Systems nor its board
of directors.
