Improve data access in SAP environments with the Oracle Cost Based Optimizer (CBO)

by Martin Frauendorfer, Platinum Support Consultant, Active Global Support, SAP AG

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 Optimizer1 (RBO), the CBO is more sophisticated and complex, but it also has a few drawbacks.

Categories: Database Administration, Performance Optimization, System Administration

Would you like to see the full version of this article?

If you are an electronic license holder to SAP Professional Journal, please click here to log in.

If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in the SAP Professional Journal online knowledgebase — click here to see the available subscription options.

Or call 1-781-751-8799 to speak directly with a subscription and licensing specialist about customized access for you and your team.

Isn't your SAP implementation worth world-class information support?

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@sappro.com.
SAP Professional Journal, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.