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
(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@xxxxxxxxx>: > 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 -- //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/