SQL Optimizer

The SQL optimizer is an internal component of the 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).

How SQL Statements Are Processed
How the SQL Analyzer Estimates the Costs of SQL Statements
SQL Optimizer Statistics
Search Conditions
Search Strategies
Analyzing Search Strategies Using the EXPLAIN Statement

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

SAP Note 819324 (FAQ: MaxDB SQL Optimization)
SAP Note 927882 (FAQ: MaxDB Update Statistics)
Database Administration, Analyzing the Database Performance