1、Step 1: You could define an MQT as follows
步驟1：您可以像下面這樣定義一個MQT

2、How is the decision made to use an MQT to answer a query?
如何作出在查詢中使用MQT的決策？

3、As the data for the base table changes, the MQT needs to be updated accordingly.
當(dāng)基本表中的數(shù)據(jù)發(fā)生改變時，需要相應(yīng)地更新MQT。

4、Step 4: Populate the MQT with data.
步驟4：用數(shù)據(jù)填充m qt。

5、Step 8: Enable the MQT to be considered for optimization.
步驟8：允許為優(yōu)化考慮mqt。

6、An MQT is a table whose definition is based on the result of a query.
MQT是基于一個查詢的結(jié)果而定義的表。

7、The clauses in the definition of MQT dictate the behavior of the MQT.
MQT定義中的子句指出MQT的行為。

8、Also assume that the MQT aggregate_sales exists as described before.
還與前面描述的一樣，假設(shè)MQT aggregate_sales已經(jīng)存在。

9、Populating a user-maintained MQT with data.
用數(shù)據(jù)填充用戶維護的mqt。

10、Populating a federated_tool-maintained MQT with data.
用數(shù)據(jù)填充federated _ tool維護的mqt。

11、When an access plan USES an MQT, the db2exfmt output shows an MQT object being accessed.
當(dāng)訪問計劃使用了MQT時，db 2 exfmt輸出將展示一個被訪問的MQT對象。

12、An MQT can be indexed to provide an even greater boost to query performance.
可以在MQT上定義索引，這會進(jìn)一步提高查詢性能。

13、The section on troubleshooting helps you determine why an MQT was not used to satisfy a query.
關(guān)于故障診斷的一節(jié)幫助您確定為什么沒有使用MQT來滿足查詢。

14、Extended statistics are collected on objects referenced in the MQT definition using sampling.
擴展的統(tǒng)計信息是使用采樣在MQT定義中引用的對象上收集得到的。

15、You can think of an MQT as a kind of materialized view.
您可以將MQT看作一種物化的視圖。

16、For example, an MQT can be created on one or more tables that USES MDC and TP.
例如，可以在一個或多個使用MDC和TP的表上創(chuàng)建MQT。

17、An MQT can be defined at table creation time as maintained by the system or maintained by the user.
MQT可以在創(chuàng)建表時定義，或者定義為系統(tǒng)維護的MQT，或者定義為用戶維護的MQT。

18、Populating a system-maintained MQT with data.
用數(shù)據(jù)填充系統(tǒng)維護的mqt。

19、If the MQT happens to have a key, unique indexes should be created to reflect the fact.
如果MQT具有一個鍵，那么應(yīng)該創(chuàng)建惟一的索引以反映這一事實。

20、Of particular interest here, are the available MQT refresh policies.
比較特別的是，這種情況下可以使用mqt刷新策略。

21、For example, an MQT can be partitioned using MDC or TP.
例如，可以使用MDC或TP對MQT分區(qū)。

MQT翻譯