TIL

SQL Server Hash Join

Update yo statistics! The way the hash join works (A JOIN B or B JOIN A) is a two step process: 1. hash build. Takes input from table A and builds a hash table for it 2. hash probe. Loops table B and compares each item with the hashes from