> 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.

 

 

 

On 7/5/06, Alex Gorbachev <gorbyx@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@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