Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using index
Ng K C Paul ¼¶¼g©ó¤å³¹ <6vjqth$7dg$1_at_imsp009a.netvigator.com>...
>Is is always true that in the where clause column with Not Equal(<>) will
>not use index?
Yes. It's usually WORTHLESS to use index if there is just one "not equal" condition in the where clause. Received on Sat Oct 10 1998 - 00:00:00 CDT