ClickHouse® tips #6: Filtering data in subqueries to avoid joins
Faster JOINs without joining: use WHERE instead. This ClickHouse tip speeds up queries that don't actually need full joins.
Read the full articleYou might also wanna read
SQL Join vs Subquery: The Game Changer
When building an SQL query that involves multiple tables, there is always a constant debate about joining the tables or using subqueries.
SQLite Query Optimization: Using Uncorrelated Subqueries to Skip Correlated Subqueries for Performance Gains
Skipping expensive per-row subqueries to speed up my average query ~17%.
emschwartz.me·6mo agoQuery Data Efficiently: Best Practices
Learn how to optimize database queries efficiently with best practices, including understanding database structure, optimizing query structu
Graph Theory Approach to Worst Case Optimal Joins in Database Query Processing
09 Dec 2025
finnvolkel.com·6mo ago
Practical Guide to Real-Time Analytics Data Modeling with ClickHouse
Learn how to build sub-second real-time analytics with ClickHouse. Complete guide covering data modeling strategies, optimization techniques
ssp.sh·10mo ago
Hash, Sort-Merge, Broadcast: How Distributed Joins Work
## Query Engine Optimization - Table of Contents 1. [How Query Engines Think: The Tradeoffs Behind Every Data System](/posts/2026-04-29-quer
Comments
Sign in to join the conversation.
No comments yet. Be the first.