DB2 MATERIALIZED QUERY TABLE

Materialized Query Table(MQT)

  1. A materialized query table is a table whose structure and definition are based on the result of a given query.
  2. Materialized query table gets its data from the same query. And MQT actually contains that data.
  3. That query may contain more than 1 table.
CREATE TABLE mqt-name AS (select-statement) mqt-options
CREATE TABLE TRANS_REPORT AS