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 most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
A hash join is usually faster than a sort merge join since there is no sort operation involved.
哈希连接通常比分类合并连接快，因为它没有涉及到分类操作。
Merge scan join (MSJOIN) with sort for outer and inner
使用内部和外部排序的合并扫描联接 (MSJOIN)
If the query includes a join, the optimizer must determine the join plan (hash, sort merge, or nested loop), and the order in which tables are evaluated or joined.
如果该查询包含了连接，那么优化器就必须确定连接计划(hash、sort merge或nestedloop)，以及评估或连接表的次序。
Listing 1. Merge-sort using the fork-join library.
清单1.使用fork - join库进行合并排序。
Listing 1. Merge-sort using the fork-join library.
清单1.使用fork - join库进行合并排序。
应用推荐