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的提示和技巧？
Populating a federated_tool-maintained MQT with data.
用数据填充federated _ tool维护的mqt。
Step 8: Enable the MQT to be considered for optimization.
步骤8：允许为优化考虑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已经存在。
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时需要仔细地确定要使用的子句。
An MQT can be indexed to provide an even greater boost to query performance.
可以在MQT上定义索引，这会进一步提高查询性能。
Users may also make use of the 'LOAD' utility to populate the MQT with data.
用户也可以使用'LOAD '实用工具来用数据填充m QT。
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来满足查询。
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。
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。
The MQT is populated with the data once and is reused by multiple queries, providing performance benefit.
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所基于的昵称之间。
In such a system, it is possible to specify the partitioning of an MQT or to define it as a REPLICATED MQT.
在这样的系统中，有可能指定MQT的分区或者将它定义为REPLICATED MQT。
Generally, ETL processes manually specify when to update MQT rather than allow this to happen automatically.
通常，ETL过程是手动地指定何时更新MQT，而不是让更新自动发生。
应用推荐