Component documentationSQL Optimizer Locate this document in the navigation structure


The database system uses the SQL Optimizer internally to determine the best search strategy for accessing the data records. The SQL Optimizer analyzes SQL statements sent to the database by users or applications. If certain search conditions have been specified in the SQL statement, SQL Optimizer can optimize access to the data. It determines the costs for the SQL statement and then chooses the best search strategy.


The SQL Optimizer is part of the database system. In SAP systems, you can display information about the SQL Optimizer with the DBA planning calendar and schedule actions for updating the SQL Optimizer statistics. See Database Administration in CCMS, SQL Optimizer in CCMS.

More Information

Database Administration, Analyzing the Database Performance

SAP Note 927882