218 DB2 Cube Views: A Primer
Building efficient MQTs is a difficult and time consuming task if done by hand. As
an alternative, we show that using the OLAP Center’s Optimization Advisor is a
tool that not only eliminates the laborious MQT construction job for the DBA, but
also does a very good job of constructing them based on the knowledge provided
in the OLAP Center cube model and accompanying cubes.
We provide an insight into the working of the Optimization Advisor as well as
MQTs in general and show what design considerations are beneficial to their
By briefly analyzing some examples from our sample data mart, we show how
MQTs may be deployed, ensuring that they are used, and ultimately how they
may highly benefit queries.