The DB2 optimizer is a highly sophisticated cost-based optimizer.
DB 2优化器是一款高度复杂的基于成本的优化器。
Only statistics stored in the dictionary itself have an impact on the cost-based optimizer.
只有存储在字典视图中的统计信息,才会被优化器使用。
This set is input to the cost-based optimizer that decides whether to use any of the eligible indexes or not.
将该组索引输入到基于成本的优化器,这个优化器决定是否使用任何合适的索引。
This algebra is exploited by a cost-based optimizer that can freely mix regular and compression-aware operators.
该代数由基于成本的优化器使用,该优化器能够自由混合使用常规运算符以及与压缩有关的运算符。
IBM does not publish the actual, in-depth details of how the optimizer determines the best access path, but the optimizer is a cost-based optimizer.
IBM并没有发布优化器如何确定最佳存取路径的真正和深入的详细信息,但优化器是一个基于成本的优化器。
One of the distinguishing features of Federation Server is that it uses the powerful technology of DB2's cost-based optimizer to find the best access path for federated queries.
FederationServer的一个独特的特性是,它使用DB2强大的基于成本的优化器技术来发现联邦查询的最佳访问路径。
WebSphere Federation Server USES its cost based optimizer in order to determine the optimal access path to retrieve and process the data.
WebSphereFederationServer使用它的基于成本的优化器,确定检索和处理数据的最佳路径。
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.
为了实现星型连接查询的最佳执行计划,优化器在适当的时候会考虑星型连接优化,并根据成本因素来决定星型连接计划。
When this attribute is not specified, the optimizer makes a cost-based decision to select an access plan for the given table.
如果未指定该属性,优化器将生成一个基于成本的决策,为给定的表选择一种访问计划。
The optimizer picks additional indexes for the IXAND plan in a cost-based fashion.
优化器将以一种基于成本的方式为IXAND计划挑选额外的索引。
Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer.
准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。
The optimizer may add more indexes to the IXAND plan in a cost-based fashion.
优化器可能会以一种基于成本的方式将更多索引加入到 IXAND计划中。
DB2 UDB comes with a powerful cost-based query optimizer that determines the best strategy to access data.
DB 2 UDb中包含了一个功能强大基于成本的查询优化器,用于确定访问数据的最佳策略。
The optimizer chooses between the two access methods using a cost-based analysis.
优化器将通过基于成本的分析来在这两个访问方法之间进行选择。
The optimizer will add more indexes to the IXAND based on cost.
优化器将根据成本向IXAND添加更多索引。
The optimizer compares the cost of each candidate access path based on the information from multiple inputs, for example, see the following.
优化器根据多个输入的信息来对比候选访问路径的成本,如下例所示。
The optimizer may pick an XISCAN, IXAND, XANDOR, or RIDSCN plan using cost-based analysis.
优化器可能会通过基于成本的分析选择XISCAN、IXAND、XANDOR或RIDSCN计划。
The optimizer may pick an XISCAN, IXAND, XANDOR, or RIDSCN plan using cost-based analysis.
优化器可能会通过基于成本的分析选择XISCAN、IXAND、XANDOR或RIDSCN计划。
应用推荐