The following guideline was created to influence the optimizer to consider I11 index, and substantially improved the time to refresh the MQT mqt1 by more than 2X.
但是，可以通过创建下面的指南来影响优化器，使之考虑I11索引，从而将 MQT mqt1 的刷新速度提高两倍以上。
Populating a user-maintained MQT with data.
用数据填充用户维护的mqt。
Populating a system-maintained MQT with data.
用数据填充系统维护的mqt。
Make sure the MQT is enabled for optimization.
确保为优化启用了MQT。
Hints and tips on why a query is not using an MQT.
关于查询为什么不使用MQT的提示和技巧？
For example, an MQT can be partitioned using MDC or TP.
例如，可以使用MDC或TP对MQT分区。
Step 10: Find out whether MQT is being used to answer a query.
步骤10：找出是否使用MQT来回答查询。
DB2 can automatically rewrite a query to take advantage of an MQT.
DB 2可以自动地重写查询以使用MQT。
Also assume that the MQT aggregate_sales exists as described before.
还与前面描述的一样，假设MQT aggregate_sales已经存在。
Computations common to multiple queries can be represented using an MQT.
对多个查询公共的计算可以使用MQT来表示。
A user does not need to change the query in order to make use of the MQT.
为了使用MQT，用户不必要更改查询。
One needs to carefully determine the clauses to use while creating an MQT.
创建 MQT时需要仔细地确定要使用的子句。
An MQT can be indexed to provide an even greater boost to query performance.
可以在MQT上定义索引，这会进一步提高查询性能。
For example, an MQT can be created on one or more tables that USES MDC and TP.
例如，可以在一个或多个使用MDC和TP的表上创建MQT。
Listing 2 shows an example of creating a REFRESH DEFERRED user-maintained MQT.
清单2展示了一个创建REFRESHDEFERRED类型的用户维护的MQT的例子。
Listing 1 shows an example of creating a REFRESH IMMEDIATE system-maintained MQT.
清单1展示了一个创建REFRESHimmediate类型的系统维护的MQT的例子。
As the data for the base table (s) changes, the MQT needs to be updated accordingly.
当基本表中的数据发生改变时，需要相应地更新MQT。
If your query is not using an MQT and you believe it should be, check the following.
如果您的查询未使用MQT，而您认为它应该使用，那么请检查。
If the MQT happens to have a key, unique indexes should be created to reflect the fact.
如果MQT具有一个键，那么应该创建惟一的索引以反映这一事实。
The MQT refresh is triggered when the table tab2 involved in its definition is populated.
当为MQT定义中涉及的表tab2填充数据时，就会触发对MQT的刷新。
MQT recommendations (first new ones, then existing ones to keep, and finally unused ones).
MQT建议(首先是新的MQT，然后是要保留的已有的MQT，最后是未使用的MQT)。
Extended statistics are collected on objects referenced in the MQT definition using sampling.
扩展的统计信息是使用采样在MQT定义中引用的对象上收集得到的。
The section on troubleshooting helps you determine why an MQT was not used to satisfy a query.
关于故障诊断的一节帮助您确定为什么没有使用MQT来满足查询。
Make sure that the tables referenced in the MQT are a subset of tables referenced in the query.
确保MQT中引用的表是查询中引用的表的一个子集。
Not supported are range clustered tables (RCT), materialized query tables (MQT), and typed tables.
不支持范围簇表（RCT）、物化查询表（MQT）和有类型的表。
An MQT can be defined at table creation time as maintained by the system or maintained by the user.
MQT可以在创建表时定义，或者定义为系统维护的MQT，或者定义为用户维护的MQT。
Make sure that the predicates applied by the MQT are a subset of the predicates applied by the query.
确保MQT应用的谓词是查询应用的谓词的一个子集。
In fact, the support of statistical view shares some similar limitations to the support of MQT in DB2.
实际上，DB 2中对统计视图的支持与对MQT的支持具有类似的局限性。
The MQT must reference the whole hierarchy of nicknames from the root nickname to that child nickname.
MQT必须从根昵称到这个子昵称引用昵称的整个层次结构。
This article introduced the following DB2 table design features: table partitioning, MDC, DPF, and MQT.
本文介绍了以下DB2表设计特性：表分区、MDC、DPF和 MQT。
应用推荐