Articles by tag: database-partitioning

MergeTree in ClickHouse: granules, parts, and sparse index

MergeTree structure using a bids table example: part, granule, mark, merge of parts, ORDER BY vs PRIMARY KEY, partitioning, EXPLAIN indexes, partition management.