Oracle Cost Based Optimizer (CBO)

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.

RECENTLY ADDED

Set Up a Trusted Relationship Between SAP NetWeaver AS Java and ABAP for Secure SSO

Build Rich Internet Applications in SAP Using Web Dynpro ABAP and Flex

Discover More Options for SAP E-Recruiting with Web Dynpro ABAP

Optimize Application Integration by Running Risk Analysis and Remediation for SAP NetWeaver Portal

SAP NetWeaver Business Rules Management: Tips for Testing and Working with Business Rules

Subscribe to the RSS feed.

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.