优化后的执行计划输出显示出了极大的提高。
The execution plan output after the optimization showed a significant improvement.
目前的执行计划仍然具有法律效应。
他们只是按被告知的执行计划。
后续调用不会再探测，而是重用之前的执行计划。
Subsequent invocations will not peek and the previous execution plan will be reused.
缓存提高性能的执行计划。
第三章谈到了如何读取基于文本和XML的执行计划。
Chapter 3 is about reading text and XML-based execution plans.
评估查询的执行计划。
这样做是为了确保SQL过程的执行计划是正确的。
This is done early to ensure execution plans for SQL procedures are correct.
如果你完成了打扫厨房就在前一天一个新的执行计划？
What if you completed cleaning the kitchen just the day before a new execution is scheduled?
查询优化器使用表和索引的统计信息去决定最优的执行计划。
The query optimizer USES statistics gathered on tables and indexes when determining the optimal execution plan.
DB 2 9.7忽略了这个语法差别，并选择表5中开销更小的执行计划。
DB2 9.7 disregards this syntactical difference and chooses the cheaper of the two execution plans in Table 5, based on cost and cardinality estimates.
总而言之，如果有可用的XML统计信息，DB 2可以生成更好的执行计划。
In a nutshell, the DB2 does generate better execution plans if XML statistics are available.
当禁用异步时，异步的动机小节中的查询的执行计划很可能是这样的。
With asynchrony disabled, a likely execution plan for the query from the motivation section is.
准备洗车站的执行计划和状况报告，确保计划按照具体要求得以执行；
Prepares car wash station execution plan and status reports and work to ensure plans adhere to required specifications.
因此，在第一次编译sql语句之后，后来的调用只要继续执行相同的执行计划即可。
Subsequent invocations will simply keep executing the same execution plan. Let's use an example.
查看SQLServer查询的执行计划是一回事，而明白它们的含义却是另一回事。
It is one thing to look at the execution plan for SQL Server queries, it is quite another to know what they mean.
如要根据提案请求(RFP)开发响应，必须有一份构思周密的执行计划，以开发提案本身。
Developing a response for a request for proposal (RFP) requires a well-thought-out execution plan for developing the proposal itself.
和RBO计划相比，执行计划只有相同的很少，你会得到一个不同的执行计划。
There is little point comparing an execution plan to the RBO plan and being surprised if you get a different execution plan.
含异步的执行计划的主要动机是通过重叠对远程操作的处理，减少联邦语句花费的时间。
The primary motivation of execution plans with asynchrony is to reduce elapsed time of federated statements by overlapping processing of remote operations.
左侧的执行计划展示了索引AND' ing的执行计划，DB 2必须考虑捕获示例文档。
The execution plan on the left shows the index AND 'ing plan that DB2 would have to consider to catch your sample document.
该语句工具主要是研究统计sql语句的执行计划并生成报告，进而对dml语句进行检测和优化。
Generates a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is useful to monitor and tune the performance of DML statements.
这些人在行政管理方面具有天赋，喜欢与数据打交道，能够周密的执行计划或者按照他人的指示办事。
These people are talented at administration, like to work with data and can carry out tasks in detail or follow other people's instructions.
这使得我们有可能决定移植工作最终的范围和机制，从而得到一个面向构建和产品化阶段的执行计划的定义。
That made it possible to determine the final scope and mechanism for the migration, which led to the definition of an implementation plan for the Construction and Transition phases.
同时涉及本地表和远程（昵称）数据的查询特别适合于允许本地和多个远程查询片段并发和异步执行的执行计划。
Queries that involve both local tables and remote (nickname) data are candidates for execution plans that allow concurrent and asynchronous execution of local and multiple remote query fragments.
为最困难的目标制定自己的战略，但是如果事情没有按照你预期的进行，就要灵活的执行计划，降低自己的目标。
Determine a strategy to achieve the ultimate goal, but build into your plan flexibility to aim for less ambitious goals if things don't pan out the way you had planned.
在这一步中，需要使用上面讨论的工具来获取该查询的统计数据：其响应时间、详细的执行计划和成本，以便稍后进行深入分析。
At this step, you need to use the tools discussed above to get statistics on the query: its response time, its detailed execution plan, and costs for later in-depth analysis.
对于同时涉及本地表和远程（昵称）数据的查询，可以采用允许本地查询和多个远程查询片段并发和异步执行的执行计划。
Queries that involve both local tables and remote (nickname) data have the possibility of execution plans that allow concurrent and asynchronous execution of local and multiple remote query fragments.
对于涉及到MQT 的执行计划，并且该 MQT 是涉及远程表访问的计划上的 MQT，查询优化器给予它优先权。
The query optimizer will give priority to an execution plan involving an MQT over a plan that involves access to remote tables.
含联邦异步的执行计划只适用于WebSphereFederationServer的分区(启用了DPF)实例。
Execution plans with federated asynchrony are available only to partitioned (DPF-enabled) instances of WebSphere Federation Server.
含联邦异步的执行计划只适用于WebSphereFederationServer的分区(启用了DPF)实例。
Execution plans with federated asynchrony are available only to partitioned (DPF-enabled) instances of WebSphere Federation Server.
应用推荐