---
title: "ClickHouse JOINs... 100x faster"
url: https://daily.dev/posts/clickhouse-joins-100x-faster-xxttjksli
source_url: https://www.tinybird.co/blog-posts/clickhouse-joins-improvements
type: article
source: "Tinybird"
published: 2024-05-01T07:34:39.378Z
updated: 2024-05-09T09:28:18.744Z
tags: ["sql", "clickhouse"]
reading_time: 5
upvotes: 6
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# ClickHouse JOINs... 100x faster

**[Tinybird](https://daily.dev/sources/tinybird)** · 5 min read · 6 upvotes · 0 comments

## Summary

ClickHouse has introduced two new pull requests that improve JOIN performance by multiple orders of magnitude. The optimizations include JOIN predicate pushdown using equivalence classes and automatic conversion of OUTER JOINs to INNER JOINs. These optimizations significantly reduce the amount of data processed, improve index usage, and enhance query speed.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.tinybird.co/blog-posts/clickhouse-joins-improvements>

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments

---

Tags: [#sql](https://daily.dev/tags/sql), [#clickhouse](https://daily.dev/tags/clickhouse)

[View this post on daily.dev](https://daily.dev/posts/clickhouse-joins-100x-faster-xxttjksli)