Materialized Query Tables (MQTs)

A materialized query table (MQT) contains data that is derived from one or more source tables specified by a fullselect. A source table is a base table, view, table expression, or user-defined table function.
carcudb2
A
materialized query table
(MQT) contains data that is derived from one or more source tables specified by a fullselect. A source table is a base table, view, table expression, or user-defined table function.
A unique index
cannot
be created on an MQT.
MQTs can contain frequently requested information. MQTs are often used in data warehousing applications to improve SQL efficiency. However, keep the following points in mind:
  • To ensure that data is current, MQTs must be periodically refreshed (which can be expensive).
  • MQTs use storage.