Other considerations for access path selection.
选择访问路径的其他影响因素。
Access path selection: What did DB2 decide, and why?
选择访问路径:DB 2做出什么决策?为什么?
Index design has a critical impact on access path selection.
索引设计对访问路径选择至关重要。
The SQL statement itself also impacts the access path selection.
sql语句本身也会影响访问路径选择。
Statistics advisor: recommendations for collecting the required statistics to facilitate access path selection.
统计数据advisor工具:收集所需统计数据以完成访问路径的建议。
In plan optimization module, the access path selection and the account method of cost evaluation are discussed in detail.
在计划优化模块中,详细讨论了存取路径的选择和代价评估的计算方法。
In this paper, first the query technology on database is analysed, then two optimization methods are offered: the disintegration query and the best access path selection.
本文对数据库的查询技术进行分析,给出两种优化方法:分解查询和选择最优存取路径。
Before access path selection, the DB2 optimizer transforms SQL statements into forms that are semantically identical, such as by using predicate pushdown or predicate transitive closure.
在选择访问路径之前,DB 2优化器将sql语句转换成语意上一致的形式,例如使用谓词下推或谓词传递闭包。
In that case, reorganizing the index might lead to its selection as part of a better-performing query access path.
在这种情况下,重新组织索引可能会影响DB2的选择,可能产生性能更好的查询访问路径。
In that case, reorganizing the index might lead to its selection as part of a better-performing query access path.
在这种情况下,重新组织索引可能会影响DB2的选择,可能产生性能更好的查询访问路径。
应用推荐