ClickHouse JOINs... 100x faster

ClickHouse has introduced two new pull requests that improve JOIN performance by multiple orders of magnitude. The optimizations include JOIN predicate pushdown using equivalence classes and automatic conversion of OUTER JOINs to INNER JOINs. These optimizations significantly reduce the amount of data processed, improve index usage, and enhance query speed.