Materialized query tables
Materialized query tables (MQTs) are tables whose definition is based on the result of a query. The data consists of precomputed results from the tables that you specify in the materialized query table definition.
MQTs are classified by how their data is maintained. The following
types are available:
- System-maintained MQTs (MAINTAINED BY SYSTEM)
- User-maintained MQTs (MAINTAINED BY USER)
- Shadow tables (MAINTAINED BY REPLICATION)
- Federated_tool-maintained MQTs or cache tables (MAINTAINED BY FEDERATED_TOOL)
Shadow tables are also known as replication-maintained MQTs.
Federated MQTs are MQTs that have references to nicknames from relational data sources. These MQTs can be system-maintained, user-maintained, or federated_tool-maintained MQTs. For more information, see Creating a federated materialized query table.