[prev] 36 [next]

Grace Hash Join (cont)

Probe/join phase:

[Diagram:Pics/join/grace-hash2.png]

The second hash function (h2) simply speeds up the matching process.
Without it, would need to scan entire R partition for each record in S partition.