SAP® MaxDB - SQL Optimizer
This section gives detailed information about the SAP MaxDB SQL Optimizer.
SQL statements describe the content criteria, which the data that has to be accessed has to meet. But it does not describe how this data is to be accessed.
Each relational operation can, in principle, be converted into different access operations. But these can lead to different runtimes, for example, depending on the amount of data. Hence the scope of functions and the performance of the optimizer are of utmost importance.