Physical Modeling › Materialized Query Tables

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:

• Create a customized presentation of the data stored in a database.
• Restrict access to data, allowing different users access to only certain rows or columns of a materialized query table.
• Simplify database access by creating customized structures tailored to the needs of individual users. You can write a simple query on a materialized query table rather than a complex query on the actual database tables.

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