Introduction ClickHouse Index Design Using multiple primary indexes Ordering key columns efficiently Identifying single rows efficiently