Joins

Joins are a fundamental feature of relational databases. They enable the combination of rows from two or more tables based on shared values, allowing you to construct meaningful relationships across datasets.

CrateDB fully supports joins and, thanks to its distributed architecture, allows you to perform join operations efficiently even on large-scale data.

In this section, we cover:

• An overview of the supported join types and execution algorithms

• A detailed explanation of how CrateDB implements joins

• Key optimizations that enable CrateDB to handle massive datasets effectively