The most commonly used join methods are nested-loop join, sortmerge join and dynamic hash join.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
2
Also, DB2 cannot use random order index columns as part of a sortmerge join.
另外，DB 2无法在排序合并合并连接中使用随机顺序的索引列。
3
Join plan directives that force optimizer to use the designated join method to join tables in the query, either nested loop join, sortmerge join, or dynamic hash join.