Materialized Query Tables (MQTs)
-
LAB: Watch me run aggregation queries and create a Materialized Query Table on a DB2 production data warehouse instance
In this lab, I was required to create an instance of IBM DB2, load sample datasets into their respective tables, write aggregation queries and create a Materialized Query Table for BI reporting.