Re: CBO & different execution plans

"joel garry" <joel-garry_at_home.com> wrote in message news:1173312651.348951.166490_at_p10g2000cwp.googlegroups.com...
>
> Also see http://www.ixora.com.au/q+a/library.htm#10_02_2000
>
> That one made my face red years ago as I realized it was the suddenly
> obvious reason cpu's were burning on a particular app. Don't know if
> the details changed for more recent Oracle versions, but at least the
> concept should hold.
>

That is quite marginal. reduced dictionary cache load with modern computer is not so important.
There are many far more important things to consider than that.

End users will not see any difference, so do not bother about this. Received on Thu Mar 08 2007 - 02:42:03 CST