Previous Topic: Specify DB2 LUW Using Clause ParametersNext Topic: Add a Materialized Query Table


Materialized Query Tables

In a DB2 physical model, you can create materialized query tables, which are tables that are defined by a query. Materialized query tables can improve the performance of queries.

To the database user, a materialized query table looks like a real table with a set of named columns and rows of data. However, a materialized query table is not a permanently stored set of data values. The rows and columns of data visible through the materialized query table are the result of the database query that defines the materialized query table.

You can use materialized query tables for the following:

Materialized query tables are supported for Forward Engineering, Reverse Engineering, and Complete Compare.

More information:

Add a Materialized Query Table

Define the Properties of a Materialized Query Table

Specify the Materialized Query Columns

Specify the Source Tables for a Materialized Query Table

Specify Search Conditions for Generating the SQL Code for a Materialized Query Table

Specify General Physical Properties for a Materialized Query Table

Create User-Defined SQL Code for a Materialized Query Table