Re: query does not use INDEX RANGE SCAN

Jay,

Have you run DBMS_STATS on your tables and indexes? That's a start. If the index exists, there can be many reasons why the CBO (I'm assuming you are using CBO) chooses not to use the index. You'll have to start a 10053 trace to find out why the CBO is ignoring your index. You can try to force the use of the index with the INDEX optimizer hint.

HTH,
Brian

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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"