Materialized Query Tables的意思|示意

美 / / 英 / /

物化查询表

Materialized Query Tables的网络常见释义

物化查询表 物化查询表（MATERIALIZED QUERY TABLES），多维群集（MULTI-DIMENSIONAL CLUSTERING） 和并行 ..

例如物化查询表 但是现在z/OS版本开始同样具备了商业智能特性，例如物化查询表（materialized query tables, MQTs）和星型架构（star schema）。

Materialized Query Tables相关短语

1、 Materialized Query Tables MQT 物化查询表

Materialized Query Tables相关例句

The Advanced DBA exam gets into federated databases, partitioning, materialized query tables, and multidimensional clustering tables.

Advanced DBA考试涉及到联邦数据库、分区、具体化的查询表和多维集群表。

To improve performance, federation frequently USES caching, materialized query tables (MQTs), and distributed query optimization and execution.

要改进性能，联合需要经常使用缓存、物理查询表(MQT)以及分布式查询优化和执行。

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)和数据分区功能(Data Partitioning Feature, DPF)分区键的建议。

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)时，系统在完成第一阶段(ALTER TABLE DETACH PARTITION)的提交后，启动第二阶段。

Fact data is added nightly, which requires rebuilding the data cache and refreshing the materialized query tables (MQTs).

每天晚上都会添加事实数据(fact data)，这一过程需要重新构建数据缓存和重新刷新物化查询表(MQT)。

Query tables in conjunction with materialized views perform well, but they use native database joins to retrieve the related records.

将查询表与物化视图结合使用会带来很好的性能，但是它们使用本机数据库联接来检索相关记录。