---
title: "联接类型 - OceanBase 数据库 V4.3.5 | OceanBase 文档中心"
description: 联接类型 每种联接类型支持的联接算法如下表所示。 联接类型 支持的联接算法 INNER JOIN Nested Loops Join、Hash Join、Merge Join LEFT JOIN Nested Loops Join、Hash Join、Merge Join RIGHT JOIN Hash Join、M…
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.3.5 LTS

# 联接类型

更新时间：2026-04-07 20:57:20

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.3.5/zh-CN/600.manage/900.performance-tuning/400.sql-tuning/200.execution-plan-optimization/400.join-order-and-join-algorithm/300.join-types.md)  

每种联接类型支持的联接算法如下表所示。

| 联接类型 | 支持的联接算法 |
| --- | --- |
| 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 |

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线