the MQTs DDL statements are saved in the file 'my_rec_mqts.sql'.
MQTDDL语句保存在文件 'my_rec_mqts.sql' 中。
Benefits of using MQTs in the federated environment.
在联邦环境中使用MQT的优势。
Step 7: Collect statistics over MQTs using runstats.
步骤7：使用runstats收集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)。
The following sections introduce you to these two types of MQTs, as well as summary tables and staging tables.
下面的几个小节将介绍这两种类型的MQT，另外再介绍总结表和staging表。
They are a special sub-type of user-maintained MQTs, the data in which is populated by the use of Replication.
它们是用户维护的MQT的特殊子类型，其中的数据是通过使用Replication填充的。
In a federated system with the data partitioning feature, only user-maintained MQTs are supported for nicknames.
在具有数据分区功能的联邦系统中，对于昵称只支持用户维护的MQT。
The CURRENT MAINTAINED TABLE TYPES special register controls the kinds of MQTs that are considered for routing.
CURRENTMAINTAINEDTABLETYPES专用寄存器控制被考虑用于路由的 MQT的类型。
While this example USES Immediate refresh, deferred refresh MQTs are generally more compatible with ETL activity.
虽然这个例子使用立即(Immediate)刷新，但推迟刷新的MQT通常更适合ETL活动。
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的路由。
应用推荐