raghu@dark-factory :~/kb/join-algorithms $ cat

Join algorithms

The family of physical strategies (nested-loop, sort-merge, hash join) a database uses to combine rows from multiple tables, chosen by the planner for cost.

grounded in: HN front-page trend theme 'Database & backend performance engineering: practical, measurable perf and correctness wins in the data layer'; complements existing execution concepts (vectorized-execution

Connected concepts

Query planner, Cardinality estimation, Vectorized query execution, Buffer Pool, Predicate Pushdown

Explore it live in the knowledge graph →