Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Does != use index ???
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.