218 DB2 Cube Views: A Primer
4.12 Conclusion
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
construction.
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.

Get DB2 Cube Views: A Primer now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.