--- title: ClickHouse JOINs... 100x faster | daily.dev description: ClickHouse has introduced two new pull requests that improve JOIN performance by multiple orders of magnitude. The optimizations include JOIN predicate... canonical: https://daily.dev/posts/clickhouse-joins-100x-faster-xxttjksli twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: ClickHouse JOINs... 100x faster | daily.dev og:description: ClickHouse has introduced two new pull requests that improve JOIN performance by multiple orders of magnitude. The optimizations include JOIN predicate... og:url: https://daily.dev/posts/clickhouse-joins-100x-faster-xxttjksli og:image: https://api.daily.dev/og/posts/XXtTJKslI.png og:image:alt: ClickHouse JOINs... 100x faster og:image:width: 1200 og:image:height: 630 og:locale: 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: --- 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) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"ClickHouse JOINs... 100x faster","url":"https://daily.dev/posts/clickhouse-joins-100x-faster-xxttjksli","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/clickhouse-joins-100x-faster-xxttjksli"},"datePublished":"2024-05-01T07:34:39.378Z","dateModified":"2024-05-09T09:28:18.744Z","description":"ClickHouse has introduced two new pull requests that improve JOIN performance by multiple orders of magnitude. The optimizations include JOIN predicate...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/869657e107c4a82176b233a7da2d62bf?_a=AQAEuiZ","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/869657e107c4a82176b233a7da2d62bf?_a=AQAEuiZ","isAccessibleForFree":true,"articleSection":"Tinybird","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Tinybird","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/Tinybird-Avatar","url":"https://daily.dev/sources/tinybird"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/clickhouse-joins-100x-faster-xxttjksli","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":6},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"sql,clickhouse","timeRequired":"PT5M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tinybird","item":"https://daily.dev/sources/tinybird"},{"@type":"ListItem","position":3,"name":"ClickHouse JOINs... 100x faster"}]} ```