DB2 MATERIALIZED QUERY TABLE

Materialized Query Table(MQT)

Syntax for MQT

CREATE TABLE mqt-name AS (select-statement) mqt-options

for example

CREATE TABLE TRANS_REPORT AS