首批通过分布式安全可靠测评，为关键业务系统打造
联接类型
更新时间：2026-04-07 20:57:20
编辑
分享
每种联接类型支持的联接算法如下表所示。
| 联接类型 | 支持的联接算法 |
|---|---|
| INNER JOIN | Nested Loops Join、Hash Join、Merge Join |
| LEFT JOIN | Nested Loops Join、Hash Join、Merge Join |
| RIGHT JOIN | Hash Join、Merge Join |
| FULL JOIN | Hash Join、Merge Join |
| LEFT SEMI JOIN | Nested Loops Join、Hash Join、Merge Join |
| RIGHT SEMI JOIN | Hash Join、Merge Join |
| LEFT ANTI JOIN | Nested Loops Join、Hash Join、Merge Join |
| RIGHT ANTI JOIN | Hash Join、Merge Join |
