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

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

3、As the data for the base table changes, the MQT needs to be updated accordingly.
當(dāng)基本表中的數(shù)據(jù)發(fā)生改變時(shí)，需要相應(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是基于一個(gè)查詢(xún)的結(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ù)填充用戶(hù)維護(hù)的mqt。

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

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

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

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

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

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.
例如，可以在一個(gè)或多個(gè)使用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)建表時(shí)定義，或者定義為系統(tǒng)維護(hù)的MQT，或者定義為用戶(hù)維護(hù)的MQT。

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

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

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對(duì)MQT分區(qū)。

MQT翻譯