Skip indexes

ClickHouse provides a type of index that in specific circumstances can significantly improve query speed. These structures are labeled “skip” indexes because they enable ClickHouse to skip reading significant chunks of data that are guaranteed to have no matching values.

Example: minmax

Skip index bloom_filter Example

Example: skip index bloom_filter & array column

Skip indexes examples