This brings little overhead for compiling, but gives an optimal access plan.
这会增加一些编译负载，但却能够产生一个最优的存取计划。
The optimizer takes account of these changes and selects the optimal access plan when the job is executed.
而优化器会考虑这些变化，并且在作业执行时选择最佳访问计划。
As you've seen in the steps above, the optimizer selects the optimal access plan based on available statistics.
您可以从以上步骤看到，这个优化器基于可用的统计信息选择了最优的存取计划。
Having the DBMS determine the optimal access path to the data lifts a heavy burden off the programmer's shoulders.
让DBMS确定到数据的最优存取路径解除了程序员肩上沉重的负担。
WebSphere Federation Server USES its cost based optimizer in order to determine the optimal access path to retrieve and process the data.
WebSphereFederationServer使用它的基于成本的优化器，确定检索和处理数据的最佳路径。
We analyze the optimal access price in the asymmetric information by means of modern incentive theory.
本文利用现代激励理论分析了信息不对称情况下的输配电环节的最优接入定价问题。
Finally, the optimal access network was chosen through the weighted ranking of the relative membership degree.
最后，通过对相对隶属度的加权排序，得到最优接入网络。
Ideally, the database will choose the most optimal access plan — that is, the plan that returns the data the most efficiently and quickly.
理想情况下，数据库将选择最佳访问计划——也就是能够最有效、最快地返回数据的计划。
If the SQL statement is badly coded, it is difficult for the optimizer to transform the query, leaving fewer options available for choosing an optimal access path.
如果sql语句设计得很糟，优化器就很难转换查询，在选择最佳访问路径时的选择就很少。
As we've discussed in this article, the DB2 optimizer may choose a sub-optimal access plan when there are host variables or parameter markers in the SQL statement.
正如我们在本文讨论的，如果sql语句中存在主机变量或参数标记，那么DB 2优化器可能会选择一个次优化的存取计划。
Without column data-value distribution information in the catalog, DB2 will assume an even distribution of values, which may lead the optimizer to a sub-optimal access path.
如果编目中没有列数据值分布信息，DB 2就会假设值是均匀分布的，这可能导致优化器选择非最优的访问路径。
However, if literals are important to get optimal access plans, the shorter execution times of the SQL statements are more important than the elegancy of the application's source code.
但是，如果文本对于获取最优访问计划很重要，那么更短的sql语句执行时间比应用程序源代码的优雅性更重要。
Ideally, the database chooses the most "optimal" access plan — that is, the plan that returns the data most efficiently and quickly.
在理想情况下，数据库会选择最“优化”的访问计划——也就是最高效最快地返回数据的计划。
Ideally, the database chooses the most "optimal" access plan — that is, the plan that returns the data most efficiently and quickly.
在理想情况下，数据库会选择最“优化”的访问计划——也就是最高效最快地返回数据的计划。
应用推荐