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