Hashed Join Algorithm
Algorithm (for equi-join):
- Hash each of R and S on the join attributes, using the same hash function
- each bucket of collisions is a partition
- For each pair of corresponding partitions of R and S:
- hash again using a different hash function
- r and s which hash the second time to the same bucket can be checked; output if match