Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: using index
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
![]() |
![]() |