RE: [sqlite] Re: Index not used with "between"

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

Re: [sqlite] Re: Index not used with "between"

> Hmm... nobody has an answer? Or did my message get eaten by a spam filter > :( > > On Apr 4, 2005 8:02 PM, Cory Nelson <[EMAIL PROTECTED]> wrote: >> Using the following: >> >> create table t_history(time real, ...); >> create index i_time on t_history(time); >> select count(*) from t_history

[sqlite] Re: Index not used with "between"

Hmm... nobody has an answer? Or did my message get eaten by a spam filter :( On Apr 4, 2005 8:02 PM, Cory Nelson <[EMAIL PROTECTED]> wrote: > Using the following: > > create table t_history(time real, ...); > create index i_time on t_history(time); > select count(*) from t_history where time