The new cost-based join optimizer with reordering support for non-inner joins

T1Covered by 1 source · first reported by Databricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale at 28 Oct, 14:12 UTC

ClickHouse’s new exhaustive cost-based join optimizer safely reorders inner, outer, semi, and anti joins to find the cheapest valid plan.

Sources

• T1The new cost-based join optimizer with reordering support for non-inner joinsDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale28 Oct, 14:12