Step 4: Populate the MQT with data.
步骤4：用数据填充m qt。
步骤1：创建MQT。
Step 1: You could define an MQT as follows
步骤1：您可以像下面这样定义一个MQT
An MQT can also make use of partitioning features.
MQT也可以使用分区特性。
You can think of an MQT as a kind of materialized view.
您可以将MQT看作一种物化的视图。
How is the decision made to use an MQT to answer a query?
如何作出在查询中使用MQT的决策？
The data is loaded into the MQT using the "load command".
使用“Load命令”将数据加载到MQT中。
Of particular interest here, are the available MQT refresh policies.
比较特别的是，这种情况下可以使用mqt刷新策略。
An MQT is a table whose definition is based on the result of a query.
MQT是基于一个查询的结果而定义的表。
Note that the query has been rewritten to access the aggregate_sales MQT.
注意，该查询被重写来访问aggregate_salesMQT。
Step 3: At this point you may want to consider defining indexes on the MQT.
步骤3：这时，您可能需要考虑在MQT上定义索引。
Step 3: Use SET INTEGRITY statement to bring an MQT out of check-pending state.
步骤3：使用SETintegrity语句使MQT脱离check - pending状态。
Here 'sample' is the schema under which the MQT aggregate_sales has been created.
这里的'sample '是模式，MQT aggregate_sales是在该模式下创建的。
Here 'sample' is the schema under which the MQT aggregate_sales has been created.
这里的'sample '是模式，MQT aggregate_sales是在该模式下创建的。
应用推荐