You can improve retrieval performance by modifying the SQL statements and index definitions on the basis of pdvwopt's output result.

Modifying the access path may not always result in improved performance, depending on the data characteristics. When modifying the access path, be sure to evaluate the performance.

Organization of this section

17.6.1 Examples of tuning procedure

17.6.2 Notes about index definitions

17.6.3 Notes about index retrieval

17.6.4 Notes about join retrieval