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 the DB2 chooses matching index access when other access methods might result in performance problems.

Parent topic: Writing efficient SQL queries

Related tasks:

Modifying catalog statistics to influence access path selection

Managing and preventing access path change