Introduced a full sorting merge join algorithm in ClickHouse.
Why it matters
The new full sorting merge join algorithm improves the efficiency and performance of join operations by enabling fully sorted merge joins. This enhances the capability to process large datasets more effectively and provides better join optimization compared to existing methods.How to use it
Users can benefit from the full sorting merge join algorithm automatically when performing join operations that meet the necessary sorting requirements. Ensure that joined tables are sorted appropriately to enable the use of the merge join algorithm.