Materialized Query Tables
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 | |
---|---|
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ | |
✓ |