If you data to join looks like not very huge dictionaries[1] (locations, types, etc) then ClickHouse can show amazing speeds. I had no any problems with a speed

If you data to join looks like not very huge dictionaries[1] (locations, types, etc) then ClickHouse can show amazing speeds. I had no any problems with a speed of usual joins though. [1] https://clickhouse.com/docs/en/sql-reference/dictionaries/ https://clickhouse.com/docs/en/sql-reference/dictionaries/