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 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.