ClickHouse Black Magic: Skipping Indices
ClickHouse indices are different from traditional relational database management systems. Instead, ClickHouse uses secondary ‘skipping’ indices. Those are often confusing and hard to tune even for experienced ClickHouse users.
In this article we will dive into skipping indices and learn some of ClickHouse black magic.