Improve Data Access in SAP Environments with the Oracle Cost Based Optimizer (CBO)

  • by Martin Frauendorfer, Service Architect, Active Global Support, SAP AG
  • March 15, 2008
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.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.