Re: query does not use INDEX RANGE SCAN

From: Jay <no_at_spam.com>
Date: Thu, 4 Sep 2003 14:21:34 -0400
Message-ID: <bj7vme$1s7q$1@msunews.cl.msu.edu>

Thanks.
You are right.
When I changed smaller range it uses Index.

Thanks all!
-Jay

"mitt" <nospam_at_nospam.at> wrote in message news:3F576B91.4010703_at_nospam.at...
> Jay wrote:
> > I was wrong again. Sorry.
> > It's selecting 500097 out of 2935498
> >
>
> the percentage is high enough for the optimizer to choose a full table
> scan, which is most likely a good decision here;
> =>stay with the full table scan; it is probably fast than index range
scan;
>
Received on Thu Sep 04 2003 - 13:21:34 CDT