More background on JOIN performance and why there is a big difference. (short answer, clickhouse doesn't implement shuffle joins). https://celerdata.com/blog/from-denormalization-to-joins-why-clickhouse-cannot-keep-up