The Oracle Cost Based Optimizer (CBO) can be a powerful tool for determining the most efficient way to retrieve data from an Oracle database. The CBO identifies ways to improve data-access time by considering resource costs such as I/O, by accounting for statistical values and parameters, and by selecting appropriate indexes. Compared to the Rule Based Optimizer (RBO), the CBO is more sophisticated and complex, but it also has a few drawbacks.
Martin Frauendorfer
Martin Frauendorfer studied computer science at the University of Erlangen, Germany. He joined SAP Support in 1999 and has focused on Oracle-related problems since then. Today he works as a service architect in SAP Solution Operation Support. His main tasks involve supporting large, critical SAP customers who use Oracle databases. Key focus areas are Oracle performance tuning and Oracle administration.
You may contact the author at martin.frauendorfer@sap.com.
If you have comments about this article or publication, or would like to submit an article idea, please contact the editor.