Step 5: Create indexes over MQTS.
步骤5：在MQT上创建索引。
Restrictions on MQTs over nicknames
MQT 优于昵称的限制
Some things to remember while using MQTS.
使用MQT时应该记住的一些事情。
Benefits of using MQTs in the federated environment.
在联邦环境中使用MQT的优势。
Step 7: Collect statistics over MQTs using runstats.
步骤7：使用runstats收集MQT上的统计信息。
The table below augments table 3 with a row for MQTs.
下面的表为表3增加了关于MQT的一行。
L Size limit for the definition of new indexes or MQTs.
新的索引或MQT的定义的大小限制。
Designing MQTs in conjunction with partitioning features.
与分区特性一起设计mqt。
Step 2b: This step is specific only to user-maintained MQTs.
步骤2b：这个步骤是用户维护的 MQT 特有的。
Such MQTs can be maintained only by refreshing the whole table.
那样的 MQT只能通过刷新整个表来维护。
the MQTs DDL statements are saved in the file 'my_rec_mqts.sql'.
MQTDDL语句保存在文件 'my_rec_mqts.sql' 中。
In particular, there is a need to decide when to update the MQTs.
特别是，需要决定何时更新MQT。
Generally, MQTs are updated to remove the corresponding summary data.
通常，MQT也需要更新，以删除相应的总结数据。
The 'refresh table' command is not supported on user-maintained MQTs.
refreshtable'命令在用户维护的MQT上不受支持。
Next in the output are recommendations related to MQTs, as shown below.
输出中接下来的是关于MQT的建议，如下所示。
Restrictions on MQTs over nicknames in a partitioned database environment.
分区数据库环境中的MQT优于昵称限制。
MQTs are beneficial for various reasons. Some of them are described below.
出于各种原因，MQT是有益的。
It shows how to define MQTs suitable for a workload and how to populate them.
展示如何定义适合于工作负载的MQT，以及如何填充它们。
You can also see a partial list of the recommendations, namely, to create 3 MQTs.
您也可以看一部分建议，即创建3个MQT。
You can find more information on the "Restrictions on MQTs over non-relational nicknames" page.
您可在“MQT优于非关系昵称限制”页面找到更多信息。
And the best part is that you do not need to modify your applications to take advantage of MQTs.
最好的是，您不需要修改应用程序就可以利用MQT的优势。
You can query this view to obtain a dependency summary for the MQTs that we have created (Listing 5).
您可以查询这个视图，获得对我们创建的MQT(清单5)的依赖关系的总结。
Another way of thinking about MQTs is that they are like a view whose result set is stored in a table.
从另一种角度来看，MQT就像结果集存储在一个表中的一个视图。
Keyword 'ANY' : This setting indicates that MQTs will be considered by the optimizer to process queries.
关键字'ANY '：该设置表明MQT将被优化器考虑来处理查询。
The existence of many candidate MQTs might prevent the compiler from choosing the best MQT for that query.
许多备选MQT的存在可能会防止编译器为该查询选择最好的MQT。
The REFRESH TABLE statement (used for system-maintained MQTs) cannot be issued against user-maintained MQTs.
不能对用户维护的MQT发出REFRESHtable语句(用于系统维护的MQT)。
In a federated system with the data partitioning feature, only user-maintained MQTs are supported for nicknames.
在具有数据分区功能的联邦系统中，对于昵称只支持用户维护的MQT。
You can use steps 3 and 4 as outlined above for system-maintained MQTs, to enable routing to a user-maintained MQT.
您可以使用前面为系统维护的MQT列出的步骤3和4来启用到用户维护MQT的路由。
The next two columns represent the query execution time in seconds when MQTs are disabled and when MQTs are enabled.
下两列表示禁用MQT和启用MQT时以秒为单位的查询执行时间。
The federated query compiler makes a cost-based decision and makes the process of using MQTs transparent to the users.
联邦查询编译器作出一个基于成本的决策，并使得使用MQT的过程对用户是透明的。
应用推荐