RE: Optimizer change from 8i-9i
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <breitliw@xxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 17:43:57 +0200
Wolfgang
>Autotrace uses explain and that can produce a different plan from the
>Christian referred to the indes tie-break rule as well in his first
>reply. If there are two suitable indexes, the RBO chooses the one with
>the higher object_id (i.e. the newer one) - or is it the other way
>around?
The newer is used.
Regards,
Chris
--
//www.freelists.org/webpage/oracle-l
Other related posts:
