Blog

Engineering
The new cost-based join optimizer with reordering support for non-inner joins
ClickHouse’s new exhaustive cost-based join optimizer safely reorders inner, outer, semi, and anti joins to find the cheapest valid plan.
Fisnik Kastrati
Oct 28, 2026 · 21 minutes read
Tom Schreiber and Lionel Palacin · Oct 28, 2026
Eduardo Vellasques, Lionel Palacin and Al Brown · Oct 27, 2026
Amog Iska · Oct 26, 2026
ClickHouse · Oct 23, 2026
Hande Kafkas and Aditya Chidurala · Oct 22, 2026
ClickHouse · Oct 21, 2026
Robert Schulze · Oct 21, 2026
Eduardo Vellasques, Lionel Palacin and Al Brown · Oct 20, 2026
Amog Iska · Oct 19, 2026
Alex Soffronow Pagonidis · Oct 16, 2026
Mike Shi · Oct 15, 2026
Andrey Chudnovskiy · Oct 15, 2026
Mark Needham · Oct 15, 2026

User stories
How Ridgeline unified Iceberg and ClickHouse into one analytics layer for investment management
ClickHouse · Oct 14, 2026
Tom Schreiber and Lionel Palacin · Oct 14, 2026













