A Guide for Advanced SQL Joins: ASOF, SEMI, and ANTI joins in ClickHouse

ClickHouse AggregatingMergeTree Explained (with ReplacingMergeTree Comparison)

Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

ClickHouse Denormalization is not the answer to slow JOINs