bkmsmith (5/1/2014)

---

gbritton1 (5/1/2014)

---

Before I answered this question, I read

It reads, in part:

The hash join has two inputs: the build input and probe input. The query optimizer assigns these roles so that the smaller of the two inputs is the build input.

then later:

The hash join first scans or computes the entire build input and then builds a hash table in memory.

I'm having trouble reconciling the official description with the "correct" answer.

+1

I followed the same reference in my investigation on this QOTD. Any insight on this seemingly discrepant definition would be appreciated.

Brian