
152 DB2 Cube Views: A Primer
4.5 Using the Optimization Advisor
Basically, the Optimization Advisor is designed to create MQTs based on the
cube model, the defined cubes, the size and analysis time constraints, and the
base tables and their statistics.
This contrasts to earlier times where the MQTs would have to be built by hand,
often without the expected performance improvement or at the cost of many
hours of analysis and reiterative efforts.
In the following sections we’ll take you through the necessary steps of using the
Optimization Advisor.
4.5.1 How does the wizard work
As discussed earlier, the Optimization Advisor provided with DB2 Cube ...