Secondary indexes are supported by ClickHouse. https://clickhouse.tech/docs/en/engines/table-engines/mergetree-family/mergetree/#table_engine-mergetree-data_sk

Secondary indexes are supported by ClickHouse. https://clickhouse.tech/docs/en/engines/table-engines/mergetree-family/mergetree/#table_engine-mergetree-data_skipping-indexes https://clickhouse.tech/docs/en/engines/table-engines/merget... They are not like indexes for point lookups, but also sparse. Actually they are the best you can do without blowing up the storage.