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: Reiner Neumann <reiner.neumann_at_messe.de>
Date: 1998/10/09
Message-ID: <6vk8la$i2v$1@mail.messe.de>#1/1

You can force index-using by using a hint:

select /*+ index(mytable myindex ) */ * from mytable where auf_nr <> 4711;

but I'm not shure, that this will be faster than a full table scan .

Regards,
Reiner

Ng K C Paul schrieb in Nachricht <6vjqth$7dg$1_at_imsp009a.netvigator.com>...
>Is is always true that in the where clause column with Not Equal(<>) will
>not use index?
Received on Fri Oct 09 1998 - 00:00:00 CDT

Original text of this message

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