How Primary Keys Work in ClickHouse

Rich Raposa Director, Global Learning, ClickHouse

Primary keys in ClickHouse are not what you're used to in other DBMSs. Picking a good primary key for your MergeTree tables is critical in optimizing query performance, so it's important to understand how they work. We include an explanation of the primary index and granules.