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 my
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 the
did you try this instead of not equal?
(x >= 'abc' AND x < 'abd').
> 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,
4 matches
Mail list logo