How columnar storage actually works (and why ClickHouse is fast)

Why ClickHouse queries billions of rows in milliseconds — columnar storage, compression, and SIMD vectorization explained from first principles.