Re: query does not use INDEX RANGE SCAN

I was wrong again. Sorry.
It's selecting 500097 out of 2935498

Jay-

"Jay" <no_at_spam.com> wrote in message
news:bj7nml$1kdc$1_at_msunews.cl.msu.edu...
> 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:17:02 CDT