Maximize the performance of WebSphere Information Integrator with Materialized Query Tables 
(Anjali Betawadkar-Norwood, Valer-Alin Crisan and Eileen Lin) A materialized query table (MQT) is a table that materializes the pre-computed result of a query involving one or more tables or nicknames. After the MQT is created and populated, an arbitrary subsequent query may be satisfied by the MQT if the MQT matches all or a part of the query. Please see [1] for more details. Caching data using MQTs and allowing the query optimizer to make a cost-based decision to use the MQTs to satisfy queries is known to improve query performance in a Database Management System (DBMS).
Read Article >>
