Physical Join Operators in SQL Server - Nested Loops | SQL Server Articles

Flowchart 1 - Nested Loops The 'outer loop' consists of going through all rows from the blue input and for each row; some mysterious 'inner operator' is performed to find the matching rows from the red input. If we would use this operator to join our sets

www.dbsophic.com