The advisors can recommend RUNSTATS commands for collecting
statistics, new indexes (and show you whether existing indexes are
used by the DB2® optimizer),
revisions to an SQL statement, and ways to change an access plan.
Generating and acting on recommendations for indexes for improving the performance of single SQL statements
The Index Advisor recommends indexes that you might create
to improve the performance of the query, and enables you to create
the indexes directly from the workflow assistant, if you have the
appropriate authorities on the data server. Otherwise, you can copy
the CREATE INDEX statements and send them to someone who has the authority
to create the indexes.
Generating and acting on recommendations for changing the access paths for SQL statements
The Access Path Advisor examines the access plan that is
chosen by the optimizer and identifies certain common access path
issues. The warnings that this advisor provides can help you to understand
where to look for trouble in an access plan graph or in the Access
Plan Explorer.