Refer to the section on Materialized Query Tables.
请参阅关于物化查询表的小节。
Not supported are range clustered tables (RCT), materialized query tables (MQT), and typed tables.
不支持范围簇表(RCT)、物化查询表(MQT)和有类型的表。
Materialized query tables can significantly improve the performance of queries, especially complex queries.
物化查询表可以显著提高查询的性能,尤其是提高复杂查询的性能。
From DWE design Studio, you can design and deploy materialized query tables (MQTs) for OLAP models and cubes.
在DWE DesignStudio中,可以为olap模型和多维数据集设计和部署物化查询表(MQT)。
Nicknames do not support triggers, nor do the Materialized Query Tables (MQTs) sometimes used to cache federated data.
昵称不支持触发器,也不支持物化查询表(Materialized Query Table,MQT,有时用来缓存联邦数据)。
Fact data is added nightly, which requires rebuilding the data cache and refreshing the materialized query tables (MQTs).
每天晚上都会添加事实数据(fact data),这一过程需要重新构建数据缓存和重新刷新物化查询表(MQT)。
The database may contain materialized query tables (MQTs), the pre-joined and pre-aggregated tables for DWE OLAP models and cubes.
数据库可以包含物化查询表(MQT),即用于 DWEOLAP模型和多维数据集的预联结和预聚合的表。
The Advanced DBA exam gets into federated databases, partitioning, materialized query tables, and multidimensional clustering tables.
AdvancedDBA考试涉及到联邦数据库、分区、具体化的查询表和多维集群表。
The value of the register in turn determines what types of refresh deferred materialized query tables will be used during query optimization.
注册表的值又确定在查询优化期间将使用何种类型的刷新延迟物化查询表。
To improve performance, federation frequently USES caching, materialized query tables (MQTs), and distributed query optimization and execution.
要改进性能,联合需要经常使用缓存、物理查询表(MQT)以及分布式查询优化和执行。
WebSphere Information Integrator does not support system-maintained materialized query tables that reference nicknames in a partitioned database environment.
WebSphereInformation Integrator不支持在分区数据库环境中引用昵称的系统管理的物化查询表。
When there are no dependent materialized query tables (MQT), the system initiates the second phase after the first phase (ALTER table DETACH PARTITION) commits.
当不存在依赖的物化查询表(MQT)时,系统在完成第一阶段(ALTERTABLEDETACHPARTITION)的提交后,启动第二阶段。
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.
要学习更多关于物化查询表的知识,或者获得关于本文提及的各种主题的详细信息,请参考db 2 Information Center。
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.
它有助于消除传统性能调优的成本,比如索引、物化查询表(Materialized Query Table,MQT)、以及需要大量时间和昂贵资源的查询计划调优。
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.
可以通过定义物化查询表(Materialized Query Tables, MQT)——以前称为自动总结表(Automatic Summary Tables,AST)——来在本地缓存引用关系和非关系昵称的查询的结果。
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.
除了索引外,Design Advisor还提供关于物化查询表(MQT)、多维集群表(MDC)和数据分区功能(DataPartitioning Feature,DPF)分区键的建议。
Query tables in conjunction with materialized views perform well, but they use native database joins to retrieve the related records.
将查询表与物化视图结合使用会带来很好的性能,但是它们使用本机数据库联接来检索相关记录。
The data that is contained in an MQT is derived from one or more tables on which the materialized query table definition is based.
包含在物化查询表中的数据来自定义物化查询表时所基于的一个或多个表。
The data that is contained in an MQT is derived from one or more tables on which the materialized query table definition is based.
包含在物化查询表中的数据来自定义物化查询表时所基于的一个或多个表。
应用推荐