A large difference between actual and estimate is a warning sign that the optimizer might not have sufficient information to choose a good access plan .
如果实际值和预计值之间存在较大的差异,则表明要注意优化程序可能没有足够的信息来选择好的访问计划。
I 'll explain some definitions related to performance optimizer 1.0 .
我会解释有关性能优化器1.0的定义。
To ensure that the optimizer selects the best query plan , it is important to keep internal statistics current and accurate .
为了确保优化器选择最佳的查询计划,使内部统计数据保持为最新并且最准确的十分重要。
This can cause the query optimizer to choose a less-efficient query plan than otherwise expected .
这可能导致查询优化器选择比预期的效率低的查询计划。
The query optimizer must analyze the possible plans and choose the one with the lowest estimated cost .
查询优化器必须分析可能的计划并选择一个预计成本最低的计划。
Google website optimizer , however , is free and much more simple .
而googlewebsiteoptimizer是免费的,并且使用简单。
However , any half decent optimizer will " break " the code .
但是,即便是任何半吊子的优化,也会“破坏”这个代码的意图。
Author bio : paras chopra is the founder of visual website optimizer , world 's easiest a / b split testing software .