Nested Loops Join

SQL Server query plan explanation

Optimizing