You can subscribe to this discussion group using an RSS feed reader. RSS Feed
Method R Discussion Group

Method R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle.

Discuss Method R products, techniques, and events.

Ask new questions or post your own responses.

CBO vs Rule-Based - Webinar on 8/30/07

You indicated earlier that CBO was not used if there are no statistics and rule-based would be used. I was under the pretense that rule-based was deprecated in 10g?
Becky Goodman Send private email
Thursday, August 30, 2007
 
 
If you are on 10g, RBO is de-supported. However, you will see that the recursive Oracle SQL still use the Rule Hint. So it is still there. In 10g, if no statistics are available and if dynamic sampling is enabled, Oracle will use that and if that is not, then it will use default statistics assumptions and may apply Rule based Optimization.
Mahesh Vallampati Send private email
Friday, August 31, 2007
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Discussion Groups Main Page

Powered by FogBugz