MQT properties (DB2)

Use the Properties view to modify the properties of a DB2® materialized query table (MQT).

For more information about DB2 syntax, see the reference information that is included with each product. There may be differences between DB2 syntax and the syntax for other vendors.

General page
Property Description
Name Type a name.
Label Type a label. This label is displayed in visual diagrams.
Schema Shows the relational schema under which this object was created.
Refresh Select an option for the REFRESH clause. You can select IMMEDIATE or DEFERRED.
Optimize query Select to specify the ENABLE QUERY OPTIMIZATION option.
Maintained by Select an option for the MAINTAINED BY clause. You can select SYSTEM or USER.
Columns page
Property Description
Name Shows the name of the columns that make up the MQT.
Data Types Shows the data types of the columns that make up the MQT.
SQL page
Property Description
Expression Type an SQL expression for the MQT.
Validate Validates the SQL expression in the Expression field.
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback