Hash Join
— build a hash table, then probe
← all topics
SELECT
c.name, o.total
FROM
customers c
JOIN
orders o
ON
o.customer_id = c.id;
Build side: customers
Hash table (4 buckets, key = id % 4)
Output rows
Probe side: orders