The Art of Not Scanning Everything
This week, while the coffee is slow and the world is loud, I am quietly enjoying a ClickHouse charming Dictionary structure, watching a billion rows find their meaning in a fraction of a second.
This week, while the coffee is slow and the world is loud, I am quietly enjoying a ClickHouse charming Dictionary structure, watching a billion rows find their meaning in a fraction of a second.
In analytical databases, JOINs are often the silent killer of query performance. Today I was diving deep into the different Clickhouse JOIN algorithms and want to share with you my summary.