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.