Skip to main content

Techdocs Library > White papers >

DB2 for Z/OS: Life of MQT (Materialized query table)



Document Author:
Additional Author(s):

Pavani Rangumudri
Venkata R Mallina


Document ID:

WP102729


Doc. Organization:

Global Technology Services


Document Revised:

09/21/2017


Product(s) covered:

z/OS







Abstract: This articles provided information about MQT and its purpose. This article concentrates MQT DDL operations, MQT DML operations, MQT DCL operations, catalog information and mainly about automatic query rewrite.

DB2 MQT.pdfDB2 MQT.pdf



Classification:

Software; Solutions

Category:

Hardware/Software Maintenance

Solution(s):

Big Data and Analytics






O/S:

z/OS

Keywords:

MQT, Materialized query table, Materialized query table, MQT query optimization, Automatic query rewrite, AQR


The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more


Techdocs QuickSearch

: