Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query does not use INDEX RANGE SCAN

Re: query does not use INDEX RANGE SCAN

From: Jay <no_at_spam.com>
Date: Thu, 4 Sep 2003 12:00:04 -0400
Message-ID: <bj7nd4$1k21$1@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:00:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US