Merge join

ClickHouse's Merge Join Walks Two Sorted Streams and Skips Whole Runs

Oct 22, 2026 19 min read Jay Hubbert

ClickHouse’s merge join advances two sorted cursors in lockstep and uses a fused compare-and-run-search to skip whole equal-key runs.

ClickhousePerformanceInternalsJoinsMerge join

Read more →