Choose How to Match Keys

The same SQL JOIN can use different internal algorithms. A nested loop compares rows in turn, a hash join uses keys to look up matching rows, and a merge join advances while comparing two sorted key streams.