这一信息是非常重要的搜索引擎优化计划。
This information is vital to your search engine optimization plans.
假如必要的话，分理的应用，然而在你的脑海外一定有公道的基础的优化计划。
If you must, use it sparingly, but only after your site has been properly optimized with basic search engine optimization in mind.
协助市场资产团队执行公司店铺的资产优化计划，包括续约、降租、改造、移店、扩租等工作；
Assit the market portfolio team to carry out store's assets improving plan, including lease contract renew, rental reduction, store innovation and store relocation, space expansion etc.
为克服现有方法求解复杂水火电力系统短期发电优化计划的缺陷，提出一种新型优化算法对此类动态非线性约束优化问题进行求解。
The goal of this research is to overcome the limitations of the existing method of solving the short-term generation optimal scheduling in hydrothermal power systems.
充分了解UNIX系统在目录中放置数据的方式，有助于为系统制定卷配置计划，从而优化性能和安全性。
Understanding how a UNIX system places its data in its directories should be helpful in planning a volume configuration for your system to optimize performance and security.
因此，在进行查询计划优化时，就需要使用统计视图。
Hence, the need for statistical views arises in query plan optimization.
优化后的执行计划输出显示出了极大的提高。
The execution plan output after the optimization showed a significant improvement.
如果优化器在计划时没有必要的信息就会造成这种情况。
This can happen when the optimizer does not have the necessary information at planning time.
通过访谈、观察及有帮助的工作会话，你就可以精确定位出待改善的地方，然后制定出优化这些职能的计划。
Through interviews, observation, and facilitated work sessions, you can pinpoint improvement areas and then prescribe a plan for optimizing those functions.
因此，如果统计数据不准确或者过期，或者冲突，优化器会对查询计划中各步骤的成本评估不准确，从而导致糟糕的性能。
Consequently, if the statistics are inaccurate, outdated, or conflicting, the optimizer will create inaccurate estimates for the costs of the steps in a query plan, leading to poor performance.
当查询准备好后，数据库将分析、编译和优化执行该查询的计划。
When the query is prepared, the database will analyze, compile and optimize it's plan for executing the query.
生成访问计划，查看优化器对该查询返回的总基数(行数)的估计值。
Generate the access plan and see what the optimizer estimates the total cardinality (Number of rows) returned by the query will be.
估算成本是优化器用来比较查询计划的成本单元。
The estimated costs are cost units that the optimizer uses to compare query plans.
由于所产生的计划数量太多，仅通过分析优化器计划来调优该环境是不可行的。
Tuning such an environment by only analyzing the optimizer plans is not feasible due to the quantity of produced plans.
为了实现星型连接查询的最佳执行计划，优化器在适当的时候会考虑星型连接优化，并根据成本因素来决定星型连接计划。
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.
了解如何使用访问计划信息优化sql语句。
Learn to use access plan information to understand how to optimize your SQL statements.
在理想情况下，数据库会选择最“优化”的访问计划——也就是最高效最快地返回数据的计划。
Ideally, the database chooses the most "optimal" access plan — that is, the plan that returns the data most efficiently and quickly.
如果无法避免执行计划中出现的问题，那么可以使用准则来影响优化器计划，从而解决性能问题。
If the execution plan problems cannot be avoided, guidelines can be used to affect the optimizer plan to mitigate the performance problems.
重新优化绑定选项以改善优化器计划选择。
REOPTimizing bind options to improve optimizer plan selection.
在访问计划的编译和优化阶段提供更好的UNION处理。
Better UNION handling in the compile and optimization phase of the access plan.
使用访问计划信息帮助优化sql语句。
Use access plan information to help optimize SQL statements.
使用提示、解释计划和分析的查询优化特性。
Query optimization features using hints, explain plans, and profiling.
优化的查询及其执行计划。
确保那些SQLs拥有优化的访问计划和最佳索引。
Ensure those SQLs have optimal access plans and the best indexes in place.
它还将SQL查询编译为可执行的代码段，称为snippet，并分布这些snippet以执行它们，最后生成优化的查询计划。
It also compiles SQL queries into executable code segments called snippets, distributes the snippets for execution, and creates optimized query plans.
当优化器创建查询计划时，它将使用下列系统目录信息。
The optimizer USES the following system catalog information as it creates a query plan.
图10和图11显示了runstats如何帮助优化访问计划。
Figure 10 and Figure 11 show how runstats helped to optimize the access plan.
例子1：总是使用索引t 1x(计划优化)。
例子8：客户使用情况(计划优化)。
例子8：客户使用情况(计划优化)。
应用推荐