
Chapter 4. Using the cube model for summary tables optimization 169
4.6 Deploying Optimization Advisor MQTs
Performance optimization is a large, diverse, and oftentimes complicated subject
which the Optimization Advisor in many ways makes easy to manage. It is,
however, an ongoing process to adjust your database to changing requirements
and workloads, and here we propose a basic methodology to deal with these
issues — especially related to MQTs. We also attempt to visit some of the more
important technical details related to MQTs.
The steps described in Figure 4-20 propose a method for creating MQTs and
keeping them aligned with the workload ...