Example 8: a customer usage (plan optimization).
例子8：客户使用情况(计划优化)。
Example 1: Always use index T1X (plan optimization).
例子1：总是使用索引t 1x(计划优化)。
Example 7: Influencing Join Order 3, 4, 1, 2 (plan optimization).
例子7：影响连接顺序3、4、1、2(计划优化)。
Hence, the need for statistical views arises in query plan optimization.
因此，在进行查询计划优化时，就需要使用统计视图。
This paper focused EMS industry's production plan optimization, which is the resource leveling oriented.
本文主要研究EMS行业中面向资源能力平衡的生产计划优化。
In plan optimization module, the access path selection and the account method of cost evaluation are discussed in detail.
在计划优化模块中，详细讨论了存取路径的选择和代价评估的计算方法。
This paper focuses on the study of three mathematical models when discussing regional transit departure plan optimization.
本文在探讨区域公交发车计划优化问题过程中，主要针对三个数学模型展开研究工作。
The following examples are demonstrative of optimization profiles usage in 3 categories, namely, general optimization, query rewrite, and plan optimization.
下面的例子演示了优化概要文件在3类情况下的使用，即常规优化、查询重写和计划优化。
The major research of this paper includes: (1) Establish departure plan optimization model for regional networks of public transport and use appropriate solving method.
本文的主要研究成果包括：(1)建立适于区域网络的公交发车计划优化模型，并采用合适的方法求解。
In addition, with the comparison between the different warehouse layout and operation plan optimization results, it shows that the balanced warehouse output plan can get the best result.
此外，还通过不同出库模式下的布局和作业计划的对比分析，表明均衡的出库计划可使整体作业的效果最佳。
On the whole, the results of this research could solve the regional public transport departure plan optimization, providing constructive comments for improve transit operation and service.
综合来看，本文的研究成果较好的解决了区域公交发车计划优化问题，为公交运营管理和服务水平的改善提出了建设性意见。
In view of site selection for ore transport system in mine, general plan optimization method of main production logistics system in mine was discussed in combination with engineering design examples.
针对矿山工程设计中物流系统的选址问题，结合工程实例探讨了矿山主要生产物流系统设计的优化方法。
The guideline in the profile typically overrides the general optimization for the application settings, therefore giving good control of plan evaluation to the profile.
概要文件中的指南通常覆盖用于应用程序设置的常规优化，从而使概要文件能够更好地控制计划评估。
After you see the advantages of star join optimization, this article provides annotated explain output to show you precisely how star join plan information appears in explain file.
在您看到星型连接优化的优点后，本文通过带有注释的解释输出准确地告诉您星型连接计划的信息是如何出现在解释文件中的。
The execution plan output after the optimization showed a significant improvement.
优化后的执行计划输出显示出了极大的提高。
The optimizer considers star join optimization when appropriate and decides on star join plan based on cost considerations in order to come up with best execution plan for a star join query.
为了实现星型连接查询的最佳执行计划，优化器在适当的时候会考虑星型连接优化，并根据成本因素来决定星型连接计划。
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子句和优化指南之类的特性。
Optimization guidelines and statistical views are useful features to compensate the access plan evaluations when exceptions in query performance occur.
当查询性能中出现例外情况时，优化指南和统计视图特性对于弥补访问计划估计的不准确性非常有用。
Better UNION handling in the compile and optimization phase of the access plan.
在访问计划的编译和优化阶段提供更好的UNION处理。
Global guidelines that specify access plan parameters that are to be considered for all the statements while this optimization profile is in effect.
指定优化概要文件生效后需要对所有语句考虑的访问计划参数。
To view the query access plan using the optimization profile created, the SET CURRENT optimization profile statement can be used in combination with the SET CURRENT EXPLAIN MODE statement, as follows.
要查看使用了创建的优化配置文件的查询访问计划，可以结合使用SETCURRENTOPTIMIZATIONprofile语句和SET CURRENTEXPLAINMODEstatement，如下所示。
Based on the analysis for running performance and logs of the infrastructure system, to solve the issue in daily use and to develop the optimization plan and to implement.
通过对基础信息系统的运行性能及运行日志的分析，解决日常使用中发生的问题并制定基础信息系统的优化方案并实施。
Indicated after the rich Xin group nearly 1 year actual utilization that, the company governed the structure optimization plan to achieve the anticipated effect was practical and feasible.
经过富鑫集团近1年的实际运用表明，公司治理结构优化方案达到了预期的效果，是切实可行的。
The key problem is how to prune the big search space in order to get an optimized query plan for query parallel optimization.
并行查询优化器的目标是缩减庞大的计划搜索空间，获得优化的查询规划。
This method can guarantee the generation of optimization execution plan and costs a little.
该方法开销小，且能产生优化的执行规划。
Query optimization is the main problem of query processing research, thus in particular discusses cost estimated, query plan, search Spaces and so on related problems.
查询优化是查询处理研究的一个主要问题，为此着重分析研究了查询优化所涉及的代价估计、查询规划和搜索空间等相关问题。
The practice proves that both models can play very important role in the optimization of the production plan and enhance the yield of steel products and slab quality.
实践证明，两种控制模型对保证铸坯产品的计划优化、提高钢材收得率及提高铸坯产品质量等均起到很大的作用。
Vertical swinging of transformer and other high & low voltage switch boxes should be carried out simultaneously. Have further argument and optimization of hoisting plan before hoisting.
变压器的垂直吊运与同变电室的其他高、低压配电柜同期进行，吊装前对吊装方案进一步论证和优化。
Aiming at how the DBMS query optimizer to generate the smallest cost query plan, optimization rules of the relational algebra expression are given.
针对DBMS查询优化器如何生成成本最小的查询计划问题，给出关系代数表达式的优化规则。
Aiming at how the DBMS query optimizer to generate the smallest cost query plan, optimization rules of the relational algebra expression are given.
针对DBMS查询优化器如何生成成本最小的查询计划问题，给出关系代数表达式的优化规则。
应用推荐