MQT properties

Properties for IBM® data server MQT objects

For more information about materialized query table (MQT) syntax, see the reference information that is included with each database product. There might be differences between the IBM data server syntax and the syntax for other vendors.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Schema Shows the relational schema under which this object was created.
Refresh Specifies an option for the REFRESH clause. You can select IMMEDIATE or DEFERRED. An MQT that is REFRESH DEFERRED will not reflect changes to the underlying base tables until a REFRESH TABLE statement is issued.
Optimize query Select to specify the ENABLE QUERY OPTIMIZATION option.
Maintained by Specifies 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 Specifies an SQL expression for the MQT.
Validate Validates the SQL expression in the Expression field.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback