Re: Why is the full table scan not being chosen?

> Do you have you optimizer_mode set to first_rows by any chance?
> IIRC, this way optimizer will always choose index scan if that helps
> to avoid sorting - regardless of the cost.

>> DBFMRC=8. OPTIMIZER_MODE=FIRST_ROWS.
Looks like that's it!

Paul

On 7/5/06, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
>
> (retry due to overquote...)
>
> Do you have you optimizer_mode set to first_rows by any chance?
> IIRC, this way optimizer will always choose index scan if that helps
> to avoid sorting - regardless of the cost.
>
>
> 2006/7/5, Stuart Clowes <stuart.clowes_at_gmail.com>:
> > So, it looks to me like the FTS is cheaper, and the optimizer knows it.
> So
> > why doesn't it choose it unless I ask it to?
>
>
> --
> Best regards,
> Alex Gorbachev
>
> http://blog.oracloid.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Paul Vallee
President, The Pythian Group, Inc.
http://www.pythian.com
I blog at http://www.pythian.com/blogs/

--
http://www.freelists.org/webpage/oracle-l