In that case, reorganizing the index might lead to its selection as part of a better-performing query access path.
在这种情况下,重新组织索引可能会影响DB2的选择,可能产生性能更好的查询访问路径。
SDDPCM allows for dynamic selection of path selection algorithm options, while the AIXPCM requires each hdisk be reconfigured for a new path selection algorithm to take affect.
SDDPCM支持路径选择算法选项的动态选择,而AIXPCM需要为新路径选择算法重新配置每个hdisk才能生效。
In the procedure of path decomposition and query plan selection, target node in the query tree is utilized to avoid the transfer of the intermediate results.
在路径分解和查询计划选择的过程中,利用查询树中的目标节点来避免中间结果的传递。
应用推荐