Re: Analyze vs dbms_stats

Brian Peasland wrote:

> RBO is dead, now that 10g is out. It may have a little life in it, but
> for all intents and purposes, it is dead.

It isn't dead, it just smells funny. IT will not be dead for a long time. There is a fairly acceptable way of making CBO behave like RBO. Technically, its CBO, but effectively, it's still RBO. It must remain that until CBO gets over its initial growing pains. I've been writing a lot about CBO on this group, for the last few days. CBO is an enormous pain in the neck or lower when one has to install a patchset. Usually, there is a bug forcing me to install a patchset and, of course, there is a nagging question about the performance of the application system after the upgrade. CBO puts me into the very comfortable place between the rock and the hard place. I weasel my way out by turning CBO into RBO for the OLTP applications, so that their performance stays the same. It's akin to turning water into wine, described in a very old manual. It was much easier when RBO was supported, but isn't overly hard to do, even now. Received on Thu Jul 06 2006 - 11:41:01 CDT