Materialized Query Tables

From RapidSQL
Jump to: navigation, search

Go Up to Supported Objects

A materialized query table is a table whose definition is based on the result of a query. The materialized query table typically contains pre-computed results based on the data existing in the table or tables that its definition is based on. If the SQL compiler determines that a query will run more efficiently against a materialized query table than the base table or tables, the query quickly executes against the materialized query table.

Creating and editing

DBMS platform availability and object actions/operations supported

The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type For an introduction to object actions and details on usage of specific actions, see Object actions.

DB2 LUW

Compile

Build Query

Create Alias

Create Like

Create View

Describe

Drop

Drop Materialized Query Table

Extract

Lock

Refresh Table

Reorganize /Reorg

Report

Schema (Object Action)

Select * From

Set Integrity

Transfer Ownership

Update Statistics