Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query does not use INDEX RANGE SCAN
it selects 14 rows our of 2935498.
Thanks.
-Jay
"Turkbear" <john.greco_at_dot.state.mn.us> wrote in message
news:drnelvsabin78k8gusolhijfa4o9i3llid_at_4ax.com...
> "Jay" <no_at_spam.com> 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 % of the total rows in the table satisfies the query?
>
>
Received on Thu Sep 04 2003 - 11:00:04 CDT