Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using index
What about if I have an index with 2 columns (dept_no,emp_no)?
My where clause is something like this:
where dept_no = 10
and emp_no <> 0
fumi (fumi__at_tpts5.seed.net.tw) wrote:
:
: 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 Mon Oct 12 1998 - 00:00:00 CDT