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: Ng K C Paul <paulkcng_at_news.netvigator.com>
Date: 1998/10/12
Message-ID: <6vskis$q86$1@imsp009a.netvigator.com>#1/1

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

Original text of this message

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