MQT
美式发音: 英式发音:n.牛奶品质测定;牛奶质量测定
英文单词:物化查询表(materialized query table);创建物化查询表;物化查询表(Materialized Query Tables)
英文单词
n.1.牛奶品质测定2.牛奶质量测定
1.物化查询表(materialized query table) 7. 外连接( Outer Join) 1. 使用物化查询表( MQT) 3. 改变优化级别( Optimization Class) ...
造句带翻译释义:,牛奶品质测定,牛奶质量测定,创建物化查询表1.You can set up a task in the task center such that the refresh operation of the MQT will happen at a time of your choice.您可以在任务中心设置任务,使MQT中诸如刷新之类的操作在您选择的时间发生。
2.You can incrementally refresh a REFRESH DEFERRED MQT if it has a staging table associated with it.如果REFRESHDEFERREDMQT有一个相关联的staging表,那么可以对其执行增量刷新。
3.A materialized query table (MQT) is a table whose definition is based upon the result of a query.物化查询表(MQT)是一种以一次查询的结果为基础定义的表。
4.The staging table collects changes that need to be applied to synchronize the MQT with its underlying tables.staging表收集更改,以便应用这些更改,使得MQT与它的底层表同步。
5.The existence of many candidate MQTs might prevent the compiler from choosing the best MQT for that query.许多备选MQT的存在可能会防止编译器为该查询选择最好的MQT。
6.It gives hints and tips to determine whether an MQT is being used by the query and, if not, what prevented the use of that MQT.给出用于确定查询是否使用了MQT的提示和技巧,如果未使用,是什么防止了MQT的使用。
7.Other criteria regarding freshness of data in MQT and optimization level used for running the queries are satisfied.其他条件与MQT中数据的新鲜性和用于运行查询满足的优化级别有关。
8.The article starts out with a motivating example to show how MQTs can help query performance in the Understanding MQTs section.本文首先在理解MQT一节给出一个启发性例子,展示MQT如何可以改善查询性能。
9.The REFRESH TABLE statement (used for system-maintained MQTs) cannot be issued against user-maintained MQTs.不能对用户维护的MQT发出REFRESHTABLE语句(用于系统维护的MQT)。
10.Please note that while our workload was defined to use only one MQT per query, it is possible to use multiple MQTs to answer a query.请注意,尽管我们的工作负载被定义为每个查询只使用一个MQT,但是也可能使用多个MQT来回答一个查询。