Re: optimizer_ ???

Niall

>Ah yes, indeed I have just such an example in my recent blog on oic
>and oica (it was oica that had a similar effect for us) :) The
>original question though was after an example of improved performance
>rather than changed plans

Mhmm... I don't understand... if the execution plan doesn't change, how =
to get better performance?
Ok, one possibility, for a query with a large number of predicates, it's =
to tweak the order in which they are executed.
But this has nothing to do with OIC. The idea behind OIC is simply to =
adjust the cost of nested loops and therefore to say to the CBO that is =
has to use more/less nested loops. (since the default is 0, the original =
idea is to favor them)


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

Other related posts: