Query Execution Plan的意思|示意

To check whether the query does indeed get routed to the MQT, you can get the query Execution plan chosen by the optimizer using the SQL Explain utility and look for MQT access in the plan.

为了检查查询是否确实被路由到MQT，您可以使用SQL Explain实用程序获得由优化器选择的Query Execution Plan，并在计划中查找MQT访问。

You can analyze the query execution plan output to decide whether or not this is necessary.

您可以分析查询执行计划输出，以确定这是否是必需的。

By internal statistics, I mean the statistics in the system catalogs that the optimizer USES to determine the lowest-cost query execution plan.

通过内部统计数据，我指的是系统目录中的统计数据，优化器可以确定最低成本的查询执行计划。

Now take a look at the three new operators and how they work together with XML indexes in a query execution plan.

现在看一下这三个新操作符，以及它们与xml索引在执行计划中是如何工作的。

For the exceptional situations where the optimizer cannot choose an optimal query execution plan, DB2 has added features such as the SELECTIVITY clause and optimization guidelines.

对于优化器不能选择最佳查询执行计划的例外情况，DB 2已经增加了诸如selectivity子句和优化指南之类的特性。

For SELECT queries, the text of the remote SQL statement can be found in the details associated with the SHIP operator in the query execution plan.

对于SELECT查询，远程sql语句中的文本可以在查询执行计划中与SHIP操作符相关的细节中找到。