Products
High-quality database products to meet full lifecycle enterprise data management needs.
Resources
Various types of resources about OceanBase and the database industry
Docs
Rich content to meet the content demands of using products and solving product usage problems
OceanBase Database
Download PDF
OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.
Resources
© OceanBase 2024. All rights reserved | Cloud Service Agreement | Privacy Policy | Legal | Security
OceanBase DatabaseThe following table lists the join algorithms supported by each join type.
| Join type | Supported join algorithm |
|---|---|
| Inner join | Nested loop join, hash join, and merge join |
| Left join | Nested loop join, hash join, and merge join |
| Right join | Hash join and merge join |
| Full join | Hash join and merge join |
| Left semi join | Nested loop join, hash join, and merge join |
| Right semi join | Hash join and merge join |
| Left anti join | Nested loop join, hash join, and merge join |
| Right anti join | Hash join and merge join |
