We recently introduced two pull requests to ClickHouse that significantly improve JOIN performance in common scenarios.

Maksim KitaSource