Hash Match Join

SQL Server query plan explanation

Optimizing