One of the most known and least used join algorithms in SQL engines is MERGE JOIN. This algorithm operates on two sorted recordsets, keeping two pointers that chase each other. The Wikipedia entry above describes it quite well in terms of algorithms. I'll just make an animated GIF to make it more clear: This is quite a nice and elegant algorithm, which, unfortunately, has two major drawbacks: It n