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 quite
daunting. The Design Advisor identifies all of the objects that are
needed to improve the performance of your workload.