Correction.
It's about 3%.
Thanks.
"Jay" <no_at_spam.com> wrote in message
news:bj7nd4$1k21$1_at_msunews.cl.msu.edu...
> 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:05:09 CDT
