这种物化查询表中的数据是由用户维护的。
The data in this type of materialized query table is maintained by the user.
这种物化查询表中的数据是由系统维护的。
The data in this type of materialized query table is maintained by the system.
请参阅关于物化查询表的小节。
通过查询emp物化查询表发现，它现在已经填入了数据。
A query executed against the EMP materialized query table shows that it is now fully populated with data.
不支持范围簇表（RCT）、物化查询表（MQT）和有类型的表。
Not supported are range clustered tables (RCT), materialized query tables (MQT), and typed tables.
物化查询表可以显著提高查询的性能，尤其是提高复杂查询的性能。
Materialized query tables can significantly improve the performance of queries, especially complex queries.
注册表的值又确定在查询优化期间将使用何种类型的刷新延迟物化查询表。
The value of the register in turn determines what types of refresh deferred materialized query tables will be used during query optimization.
包含在物化查询表中的数据来自定义物化查询表时所基于的一个或多个表。
The data that is contained in an MQT is derived from one or more tables on which the materialized query table definition is based.
我们考虑物化查询表(MQT)支持一个重要的选项来进一步优化联邦服务器的性能。
We consider materialized query table (MQT) support an important option to further fine tune the performance of your federated server.
为查询提供更好的访问路径的另一种方法是使用DB2的物化查询表(MQT)功能。
Another way to provide a new and better access path for a query is through the use of DB2's materialized query table (MQT) functionality.
物理数据库设计包括表设计、索引设计、物化查询表设计，以及其他物理数据库对象的设计。
Physical database design includes table design, index design, materialized query table design, and the design of the other physical database objects.
如果查询在谓词或选择列表中具有一个函数模板，那么该函数模板必须是物化查询表的一部分。
If a query has a function template in a predicate or a select list, the function template must be part of the materialized query table.
数据库可以包含物化查询表（MQT），即用于 DWEOLAP模型和多维数据集的预联结和预聚合的表。
The database may contain materialized query tables (MQTs), the pre-joined and pre-aggregated tables for DWE OLAP models and cubes.
在DWE DesignStudio中，可以为olap模型和多维数据集设计和部署物化查询表(MQT)。
From DWE design Studio, you can design and deploy materialized query tables (MQTs) for OLAP models and cubes.
每天晚上都会添加事实数据(fact data)，这一过程需要重新构建数据缓存和重新刷新物化查询表(MQT)。
Fact data is added nightly, which requires rebuilding the data cache and refreshing the materialized query tables (MQTs).
WebSphereInformation Integrator不支持在分区数据库环境中引用昵称的系统管理的物化查询表。
WebSphere Information Integrator does not support system-maintained materialized query tables that reference nicknames in a partitioned database environment.
统计视图有点类似于物化查询表(MaterializedQueryTable,MQT)，不同的是统计视图不需要物化。
The statistical view is kind of like the Materialized Query Table (MQT), except that there is no need for materialization.
要学习更多关于物化查询表的知识，或者获得关于本文提及的各种主题的详细信息，请参考db 2InformationCenter。
To learn more about materialized query tables, or for more detailed information about any of the topics covered in this article, see the DB2 information Center.
昵称不支持触发器，也不支持物化查询表（Materialized Query Table，MQT，有时用来缓存联邦数据）。
Nicknames do not support triggers, nor do the Materialized Query Tables (MQTs) sometimes used to cache federated data.
当不存在依赖的物化查询表(MQT)时，系统在完成第一阶段(ALTERTABLEDETACHPARTITION)的提交后，启动第二阶段。
When there are no dependent materialized query tables (MQT), the system initiates the second phase after the first phase (ALTER table DETACH PARTITION) commits.
它有助于消除传统性能调优的成本，比如索引、物化查询表(Materialized Query Table,MQT)、以及需要大量时间和昂贵资源的查询计划调优。
It helps eliminate the costs of traditional performance tuning, such as indices, materialized query tables (MQTs), and query plan tuning that required extensive time and expensive resources.
除了索引外，Design Advisor还提供关于物化查询表(MQT)、多维集群表(MDC)和数据分区功能(DataPartitioning Feature,DPF)分区键的建议。
The Design Advisor now provides advice on materialized query tables (MQTs), multidimensional clustering tables (MDCs), and Data partitioning Feature (DPF) partitioning keys, in addition to indexes.
可以通过定义物化查询表(Materialized QueryTables, MQT)——以前称为自动总结表(Automatic Summary Tables,AST)——来在本地缓存引用关系和非关系昵称的查询的结果。
Materialized Query Tables (MQTs), formerly known as Automatic Summary Tables (ASTs), can be defined to locally cache the result of queries that reference relational and non-relational nicknames.
将查询表与物化视图结合使用会带来很好的性能，但是它们使用本机数据库联接来检索相关记录。
Query tables in conjunction with materialized views perform well, but they use native database joins to retrieve the related records.
将查询表与物化视图结合使用会带来很好的性能，但是它们使用本机数据库联接来检索相关记录。
Query tables in conjunction with materialized views perform well, but they use native database joins to retrieve the related records.
应用推荐