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.