Generating and acting on recommendations

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.

Feedback