DB2 10.5 for Linux, UNIX, and Windows

Establishing a performance tuning strategy

The Design Advisor
The DB2® Design Advisor is a tool that can help you significantly improve your workload performance. The task of selecting which indexes, materialized query tables (MQTs), clustering dimensions, or database partitions to create for a complex workload can be daunting. The Design Advisor identifies all of the objects that are needed to improve the performance of your workload.