MQT
英
美
abbr. 军事资格鉴定测试；军事合格考核(Military Qualification Test); 执行任务资格训练(Mission Qualification Training); 模型合格评定试验(Model Qualification Test)
双语例句
- The MQT feature provides various options for doing this to suit various operational needs.
MQT特性为适应各种运营需求而进行更新提供了多种选项。 - In particular, there is a need to decide when to update the MQTs.
特别是，需要决定何时更新MQT。 - With MQTs, when they are updated to remove the corresponding summary data, it is advisable to use table partitioning on the MQT and to define the same data partitions as on the base table.
对于MQT，当从MQT中删除相应的总结数据时，建议在MQT上使用表分区，并与基本表定义一样的数据分区。 - 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）的提交后，启动第二阶段。 - A query against this MQT right after it was created, but before the REFRESH TABLE statement was issued, returns an error.
当这个MQT刚创建且还没有发出REFRESHTABLE语句的时候，对它的查询将返回一个错误。 - However, REFRESH IMMEDIATE system-maintained MQTs are updated with changes made to the underlying tables as a result of insert, update, or delete operations.
但是，对于REFRESHIMMEDIATE类型的系统维护的MQT，可以通过对底层表的更改（即insert、update或delete操作）来更新。 - Generally, ETL processes manually specify when to update MQT rather than allow this to happen automatically.
通常，ETL过程是手动地指定何时更新MQT，而不是让更新自动发生。 - The MQT refresh is triggered when the table tab2 involved in its definition is populated.
当为MQT定义中涉及的表tab2填充数据时，就会触发对MQT的刷新。 - For example, if the base table is DPF partitioned, the design of the MQT should consider whether to replicate the MQT across the data partitions.
例如，如果基本表使用了DPF进行分区，那么MQT的设计就应该考虑是否要在各个数据库分区上复制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.
除了索引外，DesignAdvisor还提供关于物化查询表（MQT）、多维集群表（MDC）和数据分区功能（DataPartitioningFeature，DPF）分区键的建议。 - As the data for the base table ( s) changes, the MQT needs to be updated accordingly.
当基本表中的数据发生改变时，需要相应地更新MQT。 - MQTs are important because they can significantly decrease the response time for complex queries.
MQT很重要，因为它们可以显著减少复杂查询的响应时间。 - A materialized query table ( MQT) is a table whose definition is based upon the result of a query.
物化查询表（MQT）是一种以一次查询的结果为基础定义的表。 - To improve performance, federation frequently uses caching, materialized query tables ( MQTs), and distributed query optimization and execution.
要改进性能，联合需要经常使用缓存、物理查询表（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.
为查询提供更好的访问路径的另一种方法是使用DB2的物化查询表（MQT）功能。 - The REFRESH TABLE statement ( used for system-maintained MQTs) cannot be issued against user-maintained MQTs.
不能对用户维护的MQT发出REFRESHTABLE语句（用于系统维护的MQT）。 - This article introduced the following DB2 table design features: table partitioning, MDC, DPF, and MQT.
本文介绍了以下DB2表设计特性：表分区、MDC、DPF和MQT。 - Finally, MQTs also add considerations to the roll-in process.
最后，MQT还增加了转入过程中要考虑的因素。 - The use of partitioning features on the base table does not need to take into account whether MQTs will be built upon this table.
基本表上分区特性的使用不需要考虑将来是否会在这个表上创建MQT。 - Not supported are range clustered tables ( RCT), materialized query tables ( MQT), and typed tables.
不支持范围簇表（RCT）、物化查询表（MQT）和有类型的表。 - From DWE Design Studio, you can design and deploy materialized query tables ( MQTs) for OLAP models and cubes.
在DWEDesignStudio中，可以为OLAP模型和多维数据集设计和部署物化查询表（MQT）。 - Once the optimization ( such as MQTs) is created for a cube model, all the cubes derived from it benefit.
在为多维数据集模型创建了优化（比如MQT）之后，从这个模型派生的所有多维数据集都会因此受益。 - A customer experiences performance issue while refreshing an MQT as part of a batch run.
在批处理运行过程中，当刷新一个MQT时，客户会遇到性能问题。 - In fact, the support of statistical view shares some similar limitations to the support of MQT in DB2.
实际上，DB2中对统计视图的支持与对MQT的支持具有类似的局限性。 - Avoid inserting to tables with "refresh immediate" MQT's based on them.
避免将行插入到带有“refreshimmediate”MQT的表中。 - 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 database may contain materialized query tables ( MQTs), the pre-joined and pre-aggregated tables for DWE OLAP models and cubes.
数据库可以包含物化查询表（MQT），即用于DWEOLAP模型和多维数据集的预联结和预聚合的表。 - MQTs can be created based on a table that uses any combination of partitioning features.
可以在使用分区特性的任意组合的表上创建MQT。 - Generally, MQTs are updated to remove the corresponding summary data.
通常，MQT也需要更新，以删除相应的总结数据。 - Next, to populate the MQT with some data, we will import data that had been exported from the EMPLOYEE and SALES tables.
接下来，为了填充数据到MQT中，我们将导入从EMPLOYEE和SALES表中导出的数据。