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上的统计信息。
Designing MQTs in conjunction with partitioning features.
与分区特性一起设计mqt。
the MQTs DDL statements are saved in the file 'my_rec_mqts.sql'.
MQTDDL语句保存在文件 'my_rec_mqts.sql' 中。
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 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就像结果集存储在一个表中的一个视图。
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 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。
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的路由。
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的过程对用户是透明的。
The considerations for designing MQTs in conjunction with partitioning features can be summarized by the following points.
与分区特性一起设计MQT时，在设计上的考虑可以总结为以下几点。
If you have created many MQTs, all of which can be used to satisfy a query, the compilation time of the query can increase.
如果您创建了许多MQT(所有这些MQT都可以用于满足查询)，那么查询的编译时间会增加。
For example, if data from March 2003 is removed from the fact table, then summary data for that month is removed from MQTs.
例如，如果从事实表中删除了2003年3月的数据，那么也需要删除MQT中关于那个月的总结数据。
Part 2 covers additional details related to MQTs, MDCs, and DPF partitioning keys, focusing on the data warehouse environment.
第2部分将介绍关于MQT、MDC和DPF分区键的更多细节，重点分析数据仓库环境。
应用推荐