What is a merge join?

A merge join combines two sorted datasets efficiently.

It requires both inputs to be sorted on join keys and merges them like merge sort. It is highly efficient for large sorted datasets.