The optimized query and its execution plan.
优化的查询及其执行计划。
Step 2.1: Examine the query execution plan.
步骤2.1：检查查询执行计划。
Making the decision and developing an execution plan.
做出决定并开发一个执行计划。
The query execution plan can be viewed using the db2exfmt tool
这个查询执行计划可以使用db2exfmt工具查看
Illustrates how to interpret a federated query execution plan.
阐释如何解释联邦查询执行计划。
The execution plan output after the optimization showed a significant improvement.
优化后的执行计划输出显示出了极大的提高。
Subsequent invocations will not peek and the previous execution plan will be reused.
后续调用不会再探测，而是重用之前的执行计划。
If you have indexes for both predicates you may see execution plan (c) in Figure 2.
如果有用于两个谓词的索引，则可以参看图2中的计划(c)。
You can analyze the query execution plan output to decide whether or not this is necessary.
您可以分析查询执行计划输出，以确定这是否是必需的。
The 'legs' of the UNION are processed one at a time, in left-to-right order in the execution plan.
在执行计划中，UNION的几条'分支'是按照从左到右的顺序一个一个地处理的。
According to the overall query execution plan, the sub operations are then applied at the sources.
根据总体查询执行计划，将随后对数据源执行各个子操作。
What if you know your OLTP searches should use the same execution plan for different binding values?
要是你知道你的OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢？
From the data quality criteria identified, the data analyst must now design the data execution plan.
识别出数据质量标准之后，数据分析师就必须设计执行计划。
The main database configuration parameter settings that affect the query execution plan were set as follows
影响查询执行计划的主要数据库配置参数设置如下
Now take a look at the three new operators and how they work together with XML indexes in a query execution plan.
现在看一下这三个新操作符，以及它们与xml索引在执行计划中是如何工作的。
It is one thing to look at the execution plan for SQL Server queries, it is quite another to know what they mean.
查看SQLServer查询的执行计划是一回事，而明白它们的含义却是另一回事。
As part of the execution plan, investigation tests will be identified that meet the project-level data requirements.
在执行计划中，需要确定满足项目级数据需求所需的测试。
At this step, you need to dig into the statistics you collected above and take a good look at the query execution plan.
在这一步中，需要挖掘上面所收集的统计数据，并仔细查看查询执行计划。
XSCAN is not an "XML table scan" but it can appear in an execution plan after a table scan to process each of the documents.
XSCAN不是 “XML表扫描”，但在表扫描之后，它可以出现在执行计划中，用来处理每个文档。
Note that the execution plan indicates that the left leg of each hash join will return about 800,000 rows, a significant number.
注意，执行计划表明，每个散列连接的左边分支将返回大约800,000行，这是一个相当大的数字。
Recall that each SHIP operator indicates a point in the execution plan at which a query or request is sent to a remote data source.
还记得吗，每个ship操作符都意味着在执行计划中有一个地方要将一个查询或请求转发到一个远程数据源。
Developing a response for a request for proposal (RFP) requires a well-thought-out execution plan for developing the proposal itself.
如要根据提案请求(RFP)开发响应，必须有一份构思周密的执行计划，以开发提案本身。
So we added indexes on those joining columns and from the following query execution plan, we can see the query cost is greatly reduced.
因此，我们在这些连接列上添加了索引，从下列查询执行计划中我们可以看到，查询成本减少了很多。
"Dynamic" means that the query is sent into the database engine as a string; it must be parsed and have a query execution plan generated.
“动态”意味着查询作为字符串发送给数据库引擎；必须对它进行解析，并生成查询执行计划。
If the execution plan problems cannot be avoided, guidelines can be used to affect the optimizer plan to mitigate the performance problems.
如果无法避免执行计划中出现的问题，那么可以使用准则来影响优化器计划，从而解决性能问题。
How and to whom the results are reported should be documented upfront in the data quality analysis plan and indicated in the execution plan.
如何以及由谁报告结果应该在数据质量分析计划中提前指定，并在执行计划中明确说明。
From version 9.3 on, there is a nice enhancement of this utility; you can get the detailed query execution plan without ever executing the query.
从版本9.3开始，该实用程序得到了较好的提高；您可以获取详细的查询执行计划，而不必执行该查询。
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操作符相关的细节中找到。
The action begins when an application sends a query to the appliance host server, which compiles the query and creates an optimized query execution plan.
当应用程序向设备的主机服务器发送一个查询时，处理流程开始。 主机服务器将编译该查询并创建一个优化的查询执行计划。
This improves performance chiefly because the database saves all the overhead involved with calculating the execution plan for the same query over and over.
这将极大地提高性能，因为数据库节约了对相同的查询反复计算执行计划所需的所有开销。
应用推荐