This article shares the optimization techniques of subqueries and tips on handling subqueries in distributed databases.
This article introduces to ClickHouse source code and describes what happens to the kernel when executing SQL queries.
This article describes what correlated subqueries are and how to rewrite correlated subqueries as SQL queries in common semantics.
