Show TOC

SQL OptimizerLocate this document in the navigation structure

Use

The SQL optimizer is an internal component of the SAP MaxDB database. The system uses the SQL optimizer to determine the best search strategy for accessing data records in the database.

The SQL optimizer analyzes the SQL statements that are sent to the database by users or applications. If certain conditions have been specified in the SQL statement, the SQL optimizer can optimize access to the data records (cost-based optimization).

Integration

In SAP systems, you can display information about the SQL optimizer using the DBA planning calendar and schedule actions for updating the SQL optimizer statistics. For more information, see Database Administration in CCMS, SQL Optimizer in CCMS.

More Information