ClickHouse has both variants: primary and seconday indexes. Primary key is range index - to quickly locate records. Secondary indexes are data skipping indexes

ClickHouse has both variants: primary and seconday indexes. Primary key is range index - to quickly locate records. Secondary indexes are data skipping indexes - to quickly skip blocks of data.