假如必要的话，分理的应用，然而在你的脑海外一定有公道的基础的优化计划。
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.
通过访谈、观察及有帮助的工作会话，你就可以精确定位出待改善的地方，然后制定出优化这些职能的计划。
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.
在理想情况下，数据库会选择最“优化”的访问计划——也就是最高效最快地返回数据的计划。
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.
因此，项目计划应该包含数据库优化活动的时间和资源。
Therefore, the project plan should include the necessary time and resources for database specific tuning activities.
这些行动简单到难以置信，但是它们会帮助你优化你的行动计划，从而帮助你处于不断进步的状态。
These initiatives are incredibly simple, but they will help you develop your action plan to feed your continuous improvement.
重新优化绑定选项以改善优化器计划选择。
REOPTimizing bind options to improve optimizer plan selection.
使用提示、解释计划和分析的查询优化特性。
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.
迭代的、四个阶段的soa治理过程的目标是精炼并增强治理有效性，并优化对于soa计划的业务价值。
The goal of the iterative, four-phase SOA governance process is to refine and enhance governance effectiveness and optimize business value for the SOA initiative. The four phases are.
对于访问计划的每个操作符，优化器将估计该操作符的基数输出。
At each operator in the access plan, the optimizer estimates the cardinality output from the operator.
有了这个特性，查询优化器可以在决定访问计划时立即考虑索引。
With this feature, the query optimizer can immediately consider the index when determining an access plan.
优化器将选择该查询计划，因为其执行的估算成本是所有被估计划中最低的。
The optimizer chose this query plan because the estimated cost for its execution was the lowest among all the evaluated plans.
优化器将选择该查询计划，因为其执行的估算成本是所有被估计划中最低的。
The optimizer chose this query plan because the estimated cost for its execution was the lowest among all the evaluated plans.
应用推荐