It estimates the execution cost of each potential access plan based on the statistics data stored in catalog and statistics tables, and selects the one with the lowest cost.
它会基于存储在目录和统计表中的统计数据而评估每一个可能的存取计划的执行开销，然后选择最低开销的存取计划。
Note, however, that if you want to test the execution of the resulting access plan, you will still need to load data from production onto test (as much data as possible).
但是请注意，如果需要测试结果访问计划的执行，则仍然需要将尽可能多的数据从生产环境装入测试环境。
You can select more than one plan to see the status of execution work items by owners across multiple plans.
您可以选择一个以上的计划，从而查看跨多个计划的根据所有者的执行工作项的状态。
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行，这是一个相当大的数字。
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开始，该实用程序得到了较好的提高；您可以获取详细的查询执行计划，而不必执行该查询。
Later in the plan, you can provide a more detailed estimate of the test execution effort by adding a weight value to each test case.
在随后的计划中，您可以通过向每一个测试用例添加一个加权值，来提供一份详细的关于测试执行效果的估计。
It is configurable but by default it shows the status of test execution by test plan within your project.
它是可配置的，但默认显示项目中基于测试计划的测试执行的状态。
Runtime statistics can also be gathered for access plan operators during the execution of a section.
访问计划操作者也可以在一个片段执行时收集运行时统计信息。
The master test plan and a detailed planning of test effort should be all that is produced prior to test execution.
主测试计划和测试工作的详细计划，应当是在测试执行之前所产生的所有文档。
Record details of your test, such as changes you made, response time, and execution plan.
记录测试细节，例如您所做的修改、响应时间和执行计划。
Then we have an iteration plan, execution, and wrap-up which may be repeated over and again depending on the requirement of the project (followed by a post-iteration plan and finally a release).
接下来是迭代计划、执行和结束，根据项目的需求，这些步骤可能会重复多次。最后是迭代后计划和发布。
The data analyst must, as part of the execution plan, determine against which data sets the investigation tests can be run and who has access to those data sets.
在执行计划中，数据分析师必须确定运行测试所用的数据集，还要确定谁对这些数据集有访问权。
The query optimizer might come up with a different query execution plan tailored to provide good performance for fast retrieval of first 'n' rows rather than all the result rows.
查询优化器可能得出一个不同的查询执行计划，这个计划可以专门为最快地获取前'N '行，而不是所有结果行提供良好的性能。
The targeted deliverables must be clearly stated to ensure effective execution and completion of the plan.
必须清楚地陈述目标交付内容，以确保计划能够有效地执行并完成。
The DB2 9.5 optimizer USES both type of indexes to optimize the queries and help selecting the best plan for query execution.
DB 2 9.5优化器使用两种类型的索引来优化查询，并帮助选择最佳的查询执行计划。
Hence, the first step is to create a plan to guide the successful execution of the project proposal.
因此，第一步是创建一个计划，用它指导项目提案，使之得以成功执行。
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操作符相关的细节中找到。
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表扫描”，但在表扫描之后，它可以出现在执行计划中，用来处理每个文档。
A good access plan is key for the fast execution of an SQL statement.
好的访问计划对于sql语句的快速执行至关重要。
As part of the execution plan, investigation tests will be identified that meet the project-level data requirements.
在执行计划中，需要确定满足项目级数据需求所需的测试。
The plan is set; now it’s just a matter of execution.
计划已经设计好了，就等着执行了。
The correct execution plan for this join depends on the optimizer's estimate of how many of PART's 800,000 rows will be selected by the predicate involving P_RETAILPRICE.
这个连接的执行计划的正确性取决于优化器对涉及到P_ RETAILPRICE的谓词将从PART的800,000行中选择多少行这一问题的估计。
By default, Rational Quality Manager includes reporting on the status of test plan execution, on trends, and on defects.
Rational QualityManager默认包含对于测试计划执行的状态、趋势，和缺陷的报告。
Starting with the V9.7 Fix Pack 1, runtime statistics can be gathered for access plan operators during the execution of a section.
从V9.7FixPack1开始，我们就可以在一个片段执行时为访问计划操作者收集运行时统计信息。
The Requirements status by Execution report shows the status of the work items for each requirement in a test plan.
RequirementsStatusby Execution报告显示了测试计划中每个需求的工作项的状态。
When the asynchrony feature of WFS 9.1 is enabled by setting the appropriate configuration parameters, the query execution plan for the UNION ALL query illustrated above may look like this.
当通过设置适当的配置参数启用WFS 9.1中的异步特性时，前面演示的UNIONALL查询的查询执行计划如下。
You can use the output of Visual Explain or db2exfmt to obtain the query execution plan.
您可以使用VisualExplain或db 2 exfmt的输出来获得查询执行计划。
The output of the query optimizer on a federated system is the Federated Query Execution Plan (FQEP).
联邦系统上查询优化器的输出是联邦查询执行计划（FederatedQuery Execution Plan，FQEP）。
The output of the query optimizer on a federated system is the Federated Query Execution Plan (FQEP).
联邦系统上查询优化器的输出是联邦查询执行计划（FederatedQuery Execution Plan，FQEP）。
应用推荐