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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Does != use index ???

Re: Does != use index ???

From: Martin Jesterhoudt <martinj_at_worldonline.nl>
Date: 1997/08/31
Message-ID: <3409dc97.5465348@news.worldonline.nl>#1/1

On Thu, 28 Aug 1997 11:59:03 -0700, Ronak Bhatt <rbhatt_at_netscape.com> wrote:

>Does the operator " != " make use of existing index ?????

NO! The index cannot tell you what's not in the table, only what is. All references to NOT, != and <> disable index usage!

In stead of using != 0, try using > 0.


Received on Sun Aug 31 1997 - 00:00:00 CDT

Original text of this message

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