要是你知道你的OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢？
What if you know your OLTP searches should use the same execution plan for different binding values?
在这一步中，需要使用上面讨论的工具来获取该查询的统计数据：其响应时间、详细的执行计划和成本，以便稍后进行深入分析。
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.
DB 2 9.5优化器使用两种类型的索引来优化查询，并帮助选择最佳的查询执行计划。
The DB2 9.5 optimizer USES both type of indexes to optimize the queries and help selecting the best plan for query execution.
您可以使用VisualExplain或db 2 exfmt的输出来获得查询执行计划。
You can use the output of Visual Explain or db2exfmt to obtain the query execution plan.
当评估查询执行计划时，优化器计算并比较每种连接方法的成本，然后选择要使用的最佳方法。
The optimizer calculates and compares the costs of each join method and selects the best one to use when evaluating query execution plans.
虽然它有多种用途，但在执行计划停机时使用它是最合适的，它允许在不中断服务的情况下进行系统的维护。
While it has several purposes, it is best used when performing scheduling outages, which allows for system maintenance to occur with no downtime.
优化器使用高级的成本效益模型，将 TQ操作符直接放在联邦执行计划中发现的一些SHIP 操作符之上。
The optimizer uses a sophisticated cost-benefit model to consider placing TQ operators directly above some of the SHIP operators found in federated execution plans.
如果无法避免执行计划中出现的问题，那么可以使用准则来影响优化器计划，从而解决性能问题。
If the execution plan problems cannot be avoided, guidelines can be used to affect the optimizer plan to mitigate the performance problems.
上面的suma命令将返回一个suma任务ID，稍后在执行计划任务的立即下载时会使用到这个任务ID。
The above suma command will return a suma task ID that might later be used to perform an immediate download of a schedule task.
使用绑定参数的原因是让数据库一次解析sql，对后续的重复请求复用生成好的执行计划，这样做节省了CPU时间和内存。
The reason for using binding parameters is to ask the database to parse your SQL once and reuse the generated execution plan for subsequent repeat requests, which saves both CPU time and memory.
不过，在DB 2 9.7之前，查询1和查询2中的XMLEXISTS的方向决定了使用表5中的哪个执行计划。
However, prior to DB2 9.7 the "direction" of the XMLEXISTS predicate in Query 1 and Query 2 determines which of the two execution plans in Table 5 is used.
要让流准时发生，可以使用UNIXcron作业，该命令可提供丰富的语义来控制作业执行计划。
To make a flow run hourly on the hour, you can use a UNIX cron job, which can provide rich semantics to control job scheduling.
负责执行计划并使用资源，如基金，的一组人。
A group of people who are responsible for executing the initiative and allocating its resources, such as funding.
查询优化器使用表和索引的统计信息去决定最优的执行计划。
The query optimizer USES statistics gathered on tables and indexes when determining the optimal execution plan.
每一次努力的结果很大程度上取决你执行计划所使用的资源，所以不仅要确定可用的主要资源，还要确定次要资源。
The result of any effort will depend in part on the resources used to execute it, so be sure to identify not only the primary resources available but also secondary ones, too.
明确产品从使用到淘汰的服务生命周期，为每一阶段制定相应的销售计划及执行计划；
Define service brfe cycle from phase-in to phase-out; develop relevant sales and operation plan for each phase.
明确产品从使用到淘汰的服务生命周期，为每一阶段制定相应的销售计划及执行计划；
Define service brfe cycle from phase-in to phase-out; develop relevant sales and operation plan for each phase.
应用推荐