Re: query does not use INDEX RANGE SCAN

Jay wrote:

>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
>
>
>

What version of Oracle?
Which optimizer?
Are statistics current and accurate with DBMS_STATS? What does the query look like?
What is the data distribution in the table(s)? Have you tried hints?

How can anyone help you with such a scarcity of information from which to work?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)