Generating and acting on recommendations for query workloads
that run on DB2 for Linux, UNIX, and Windows
The advisors can recommend RUNSTATS commands for collecting
statistics, new statistical views and changes to existing statistical
views, and new indexes (and show you whether existing indexes are
used by the DB2 optimizer.