步骤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中。
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: At this point you may want to consider defining indexes on the MQT.
步骤3：这时，您可能需要考虑在MQT上定义索引。
应用推荐