Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Low hit ratio, but only for indexes
Hi Andy,
You are right, the <> in where clause will cause the query to not use the index.
Allan W. Tham
DBA
Received on Mon Jan 14 2002 - 20:57:27 CST