Generating and acting on recommendations for query workloads
that run on DB2 for Linux, UNIX,
and Windows
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.
Generating and acting on recommendations for BLU Acceleration
The Workload Table Organization Advisor recommends converting row-organized tables to
column-organized tables and creating shadow tables for row-organized tables that are used in
analytical queries.