Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> query does not use INDEX RANGE SCAN
Hi All,
I have a query retrieves data from table which has indexed column A.
However, when I used "A between 0 and 100", query does not use INDEX RANGE
SCAN
but TABLE ACCESS FULL.
Data type of column A is float.
"between" does not do INDEX RANGE SCAN?
Is there any way I can force it to use?
Thanks.
-Jay
Received on Thu Sep 04 2003 - 08:45:27 CDT