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.