最后是MSJOIN (3)。
Merge scan join (MSJOIN) with sort for outer and inner
使用内部和外部排序的合并扫描联接 (MSJOIN)
Relational guidelines such as join, MSJOIN, NLJOIN, and HSJOIN can be used to specify the join order and the join type.
关系准则，比如join、MSJOIN、NLJOIN和HSJOIN都可以用来指定连接顺序和连接类型。
Now, accumulate both the inner and outer to generate the query at MSJOIN (6), that is, FILTER (10) and TBSCAN (9) (same as TBSCAN (7)).
现在，把inner和outer累积起来生成MSJOIN(6)上的查询，即FILTER(10)和TBSCAN(9)(与TBSCAN(7)相同)。
Because the inner table is scanned with TBSCAN, which does not guarantee the expected order for MSJOIN, a SORT node is added to enforce the order.
因为通过TBSCAN扫描内部表，即不能对MSJOIN保证预期的顺序，所以添加sort节点来执行顺序。
Because the inner table is scanned with TBSCAN, which does not guarantee the expected order for MSJOIN, a SORT node is added to enforce the order.
因为通过TBSCAN扫描内部表，即不能对MSJOIN保证预期的顺序，所以添加sort节点来执行顺序。
应用推荐