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.