Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: using index

Re: using index

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: 1998/10/10
Message-ID: <6vp7rt$f80$1@news.seed.net.tw>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US