The workload advisors can make
several types of recommendations.
Collecting statistics The Workload Statistics Advisor enables database
administrators to collect statistics that are relevant to the SQL
statements in an entire query workload.
Creating or modifying statistical views
The Workload Statistics Advisor can recommend new statistical
views and changes to existing statistical views. Statistical views
help the DB2 optimizer to estimate
cardinality better when SQL statements have complex predicates, relationships
among complex predicates, and relationships across tables.
Creating or modifying indexes The Workload Index Advisor recommends new
indexes and changes to existing indexes on tables that are referenced
by SQL statements in query workloads.