Hello,
If I select some fields from mytable with ,where field = XX' or ,where field
> XX', the indexed fields were read indexed (displayed from IBExpert). But
If I select some fileds from mytable with 'where field is distinct from XX',
the read is not indexed.
It is already okay?
Thank
> If I select some fields from mytable with ,where field = XX' or ,where field
>> XX', the indexed fields were read indexed (displayed from IBExpert). But
> If I select some fileds from mytable with 'where field is distinct from XX',
> the read is not indexed.
>
>
>
> It is already okay?
It's an i
> Hello,
>
> If I select some fields from mytable with ,where field = XX' or ,where field
> > XX', the indexed fields were read indexed (displayed from IBExpert). But
> If I select some fileds from mytable with 'where field is distinct from XX',
> the read is not indexed.
>
> It is already okay?
H
Hi SET,
>> cannot compare IS DISTINCT FROM with equality or greater than, rather, IS
DISTINCT FROM is comparable to difference. Hence, I'd say
---
Yes, I know. I just wanted to show the comparison between indexed read (<,
>, =) and non-indexed read (is distinct.., and (thanks Thomas) also <> and
Hello Thomas,
again thanks a lot for your help!
Best regards and a nice weekend.
Olaf
> If I select some fields from mytable with ,where field = XX' or ,where
field
>> XX', the indexed fields were read indexed (displayed from IBExpert). But
> If I select some fileds from mytable with