the MQTs DDL statements are saved in the file 'my_rec_mqts.sql'.
MQTDDL语句保存在文件 'my_rec_mqts.sql' 中。
Step 5: Create indexes over MQTS.
步骤5：在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的定义的大小限制。
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只能通过刷新整个表来维护。
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的建议，如下所示。
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，以及如何填充它们。
Step 1: Use the Design Advisor to determine a set of MQTs that will help your query workload.
步骤1：使用Design Advisor来确定将会有助于改善查询工作负载性能的MQT集合。
The option -r instructs the Design Advisor to use extended statistics for the considered MQTs.
选项-r指示Design Advisor为考虑的 MQT使用扩展的统计信息。
L 700: This specifies that any new indexes, MQTs, and so on should consume no more than 700 MB.
l 700：规定任何新的索引、MQT等都不能消耗多于700 MB的空间。
And the best part is that you do not need to modify your applications to take advantage of MQTs.
最好的是，您不需要修改应用程序就可以利用MQT的优势。
In this article we focus on how to use the Design Advisor to recommend MQTs for federated queries.
在本文中，我们着重讲述如何使用Design Advisor来为联邦查询推荐MQT。
MQTs can be classified according to the mechanism that is used to populate them with data as follows
MQT可以根据以下用数据填充它们时所使用的机制来分类
The option -r has no effect when the Design Advisor is used to recommend MQTs for federated queries.
当Design Advisor用于为联邦查询推荐MQT时，选项- r没有效果。
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就像结果集存储在一个表中的一个视图。
The Design Advisor now provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
除了关于索引的建议以外，Design Advisor现在还可以提供关于MQT、MDC和DPF分区键的建议。
Keyword 'ANY' : This setting indicates that MQTs will be considered by the optimizer to process queries.
关键字'ANY '：该设置表明MQT将被优化器考虑来处理查询。
Once the optimization (such as MQTs) is created for a cube model, all the cubes derived from it benefit.
在为多维数据集模型创建了优化(比如MQT)之后，从这个模型派生的所有多维数据集都会因此受益。
The last column lists the customizations we made to the MQTs that were recommended by the Design Advisor.
最后一列列出我们对Design Advisor推荐的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)。
From DWE design Studio, you can design and deploy materialized query tables (MQTs) for OLAP models and cubes.
在DWE DesignStudio中，可以为olap模型和多维数据集设计和部署物化查询表(MQT)。
应用推荐