连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。

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.

youdao

一般来说，如果内部索引是良好的集群且预测内部表被多次探测，则使用复合排序的嵌套循环联将受到优化器的青睐。

In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.

youdao

因此，在图7中优化器选择排序嵌套循环联接的复合物。

Therefore, in Figure 7 the optimizer chooses to sort the composite for the nested loop join.

youdao