Re: [sqlite] Long retrieval times

Thanks everyone for your response. Dennis, that works great! Jay, I think I presume you meant (x >= 'a'). This works great too! Thank you again! On 8/2/05, Dennis Cote <[EMAIL PROTECTED]> wrote: > Thomas Briggs wrote: > > > > > > > > > > >>However if I use something like: > >>select * from

Re: [sqlite] Long retrieval times

Thomas Briggs wrote: However if I use something like: select * from myTable where column2!=''; (Takes a long time to return). I guess because the column in that row isn't indexed? Any alternatives? I don't believe that indices can be used to satisfy != conditions, so even if

Re: [sqlite] Long retrieval times

did you try this instead of not equal? (x >= 'abc' AND x < 'abd').

RE: [sqlite] Long retrieval times

> However if I use something like: > select * from myTable where column2!=''; > (Takes a long time to return). > > I guess because the column in that row isn't indexed? Any > alternatives? I don't believe that indices can be used to satisfy != conditions, so even if the column is indexed,