Difference
Posted: 13 May 2008 06:08 AM   [ Ignore ]
Newbie
Rank
Total Posts:  13
Joined  2008-05-07

what is CBO and RBO?
what is the diffrence between CBO and RBO?

Profile
 
 
Posted: 13 May 2008 11:45 AM   [ Ignore ]   [ # 1 ]
Newbie
Avatar
Rank
Total Posts:  18
Joined  2005-07-20

Hi,

It’s referring to:

* Rule Based Optimizer (RBO) - This method is used if the server has no internal statistics relating to the objects referenced by the statement. This method is no longer favoured by Oracle and will be desupported in future releases.
* Cost Based Optimizer (CBO) - This method is used if internal statistics are present. The CBO checks several possible execution plans and selects the one with the lowest cost, where cost relates to system resources.

Check the following link for more details:

http://www.oracle-base.com/articles/8i/CostBasedOptimizerAndDatabaseStatistics.php

Good Luck.

Daan Bakboord

Profile
 
 
   
 
 
‹‹ TAR detail      UWQ and Advanced Collections ››