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
