A hash join is usually faster than a sort merge join since there is no sort operation involved.
哈希连接通常比分类合并连接快，因为它没有涉及到分类操作。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
However, if 0 is used in the predicate, a nested-loop join would be the optimal choice instead of merge join.
然而，如果断言中使用的值为0，那么内嵌循环联接可能是最优选择，而不是合并联接。
The result set from FETCH (3) is ordered by the ID column and joined using a merge join with index I1 for T1 to get final result set.
FETCH(3)的结果集是根据ID字段排序的，并且使用T1的索引I1的合并联接而得到最终的结果集。
Join plan directives that force optimizer to use the designated join method to join tables in the query, either nested loop join, sort merge join, or dynamic hash join.
连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。
The access plan can be modeled as a Merge Join (MGJN) of the two sales tables.
访问计划可以建模为两个销售表的合并连接(Merge Join,MGJN)。
The access plan can be modeled as a Merge Join (MGJN) of the two sales tables.
访问计划可以建模为两个销售表的合并连接(Merge Join,MGJN)。
应用推荐