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.