Tagged articles

Merge Join

2 articles · Page 1 of 1

Jun 6, 2022 · Databases

Deep Dive into ClickHouse Join Implementation and Optimization Techniques

This article examines ClickHouse's join mechanisms, detailing the limitations of standard joins, the advantages of Global joins, and optimization strategies such as hash and merge joins, subquery filtering, and memory considerations, illustrated with SQL examples and source‑code analysis.

ClickHouseHash JoinMerge Join

0 likes · 16 min read

Deep Dive into ClickHouse Join Implementation and Optimization Techniques

360 Zhihui Cloud Developer

Jul 4, 2019 · Databases

Mastering SQL Joins: How Optimizers Choose the Best Access Path

This article explains how SQL optimizers choose join methods and table order, compares nested loop and merge joins, outlines factors influencing table selection, and offers practical guidance for improving multi‑table query performance.

Database PerformanceMerge JoinNested Loop

0 likes · 8 min read

Mastering SQL Joins: How Optimizers Choose the Best Access Path