|
[oracle-l]
||
[Date Prev]
[07-2006 Date Index]
[Date Next]
||
[Thread Prev]
[07-2006 Thread Index]
[Thread Next]
Re: Why is the full table scan not being chosen?
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: stuart.clowes@xxxxxxxxx
- Date: Wed, 5 Jul 2006 14:54:16 +0200
(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
--
http://www.freelists.org/webpage/oracle-l
|
