The rewritten query is shown in Figure 10.
这个已重写的查询现在如图10 所示。
The rewritten query known as "Optimized SQL" is visible when you explain the statement with the db2exfmt command.
重写后的查询也称为“OptimizedSQL”，它将在使用db2exfmt命令解释语句时出现。
When a query is submitted to DB2, it is rewritten in a form that is most suitable for optimization.
当查询被提交到DB 2后，将以一种最适合优化的方式重写它。
Note that the query has been rewritten to access the aggregate_sales MQT.
注意，该查询被重写来访问aggregate_salesMQT。
Q2 is the rewritten table name by the query rewrite.
Q2是该查询改写的表名。
If the optimizer determines that a query or part of a query could be resolved using an MQT, the query might be rewritten to take advantage of the MQT.
如果优化器确定查询或查询的一部分可以用一个MQT来解决，那么就会重写查询，以便利用MQT。
If the optimizer determines that a query or part of a query could be resolved using an MQT, the query might be rewritten to take advantage of the MQT.
如果优化器确定查询或查询的一部分可以用一个MQT来解决，那么就会重写查询，以便利用MQT。
应用推荐