Providing more information to Db2 for access path selection

In certain cases you can improve access path selection for SQL statements by providing more information to Db2.

Fetching a limited number of rows
You can specify the fetch clause in a SELECT statement to limit the number of rows in the result table of a query.
Minimizing the cost of retrieving few rows
You can improve the performance of applications that retrieve only a small subset of many qualifying rows.
Interaction between FETCH and OPTIMIZE FOR clauses
You can specify FETCH and OPTIMIZE FOR clauses in the same query.
Favoring index access
You can increase the likelihood that Db2 chooses matching index access when other access methods might result in suboptimal performance.

Parent topic: Writing efficient SQL queries

Related tasks

Modifying catalog statistics to influence access path selection
Managing and preventing access path change