Materialized Query Tables (MQT) in DB2
Posted on 2010-11-10
We have a project requirement which involves writing program that run on tables that are static. Our database is subject to constant change because the website is 24*7.
The database we use is DB2 on AS400. We were told by a consulting architect that using MQT might help us achieve what we are trying to do. And it was told that using an MQT might give us better performance as well.
Since I am new to the concept of MQT, i wanted to read on how to create, use and maintain a MQT. Any pointers or documents or web links which have details on MQT will be appreciated.