Columnar
Store column-wise. Compression per column. Only read columns needed. IO-efficient for wide tables + narrow queries.
Advertisement
MergeTree
Sort by primary key. Background merge. Similar to LSM. ReplicatedMergeTree for HA.
Advertisement
Vectorized
Process batches of values in tight loops. SIMD. Modern CPU friendly. 10-100x faster than row-at-a-time.