Also, DB2 cannot use random order index columns as part of a sort merge join.

另外，DB 2无法在排序合并合并连接中使用随机顺序的索引列。

youdao

A hash join is usually faster than a sort merge join since there is no sort operation involved.

哈希连接通常比分类合并连接快，因为它没有涉及到分类操作。

youdao

The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.

最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。

youdao