Step 4: Populate the MQT with data.
步骤4：用数据填充m qt。
步骤1：创建MQT。
Step 1: You could define an MQT as follows
步骤1：您可以像下面这样定义一个MQT
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。
An MQT can also make use of partitioning features.
MQT也可以使用分区特性。
Populating a federated_tool-maintained MQT with data.
用数据填充federated _ tool维护的mqt。
You can think of an MQT as a kind of materialized view.
您可以将MQT看作一种物化的视图。
How is the decision made to use an MQT to answer a query?
如何作出在查询中使用MQT的决策？
DB2 can automatically rewrite a query to take advantage of an MQT.
DB 2可以自动地重写查询以使用MQT。
Of particular interest here, are the available MQT refresh policies.
比较特别的是，这种情况下可以使用mqt刷新策略。
Also assume that the MQT aggregate_sales exists as described before.
还与前面描述的一样，假设MQT aggregate_sales已经存在。
The clauses in the definition of MQT dictate the behavior of the MQT.
MQT定义中的子句指出MQT的行为。
There are two ways to enable an MQT to be considered for optimization.
有两种方式允许为优化考虑MQT。
Computations common to multiple queries can be represented using an MQT.
对多个查询公共的计算可以使用MQT来表示。
One needs to carefully determine the clauses to use while creating an MQT.
创建 MQT时需要仔细地确定要使用的子句。
Step 3: At this point you may want to consider defining indexes on the MQT.
步骤3：这时，您可能需要考虑在MQT上定义索引。
An MQT can be indexed to provide an even greater boost to query performance.
可以在MQT上定义索引，这会进一步提高查询性能。
As the data for the base table (s) changes, the MQT needs to be updated accordingly.
当基本表中的数据发生改变时，需要相应地更新MQT。
If the MQT happens to have a key, unique indexes should be created to reflect the fact.
如果MQT具有一个键，那么应该创建惟一的索引以反映这一事实。
When an access plan USES an MQT, the db2exfmt output shows an MQT object being accessed.
当访问计划使用了MQT时，db 2 exfmt输出将展示一个被访问的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来满足查询。
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。
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。
The existence of many candidate MQTs might prevent the compiler from choosing the best MQT for that query.
许多备选MQT的存在可能会防止编译器为该查询选择最好的MQT。
A replication schedule is automatically set up between the MQT and the nickname on which this MQT is based.
一个复制计划被自动设置在MQT和该MQT所基于的昵称之间。
应用推荐