Broadcast Hash Join vs Sort-Merge Join.

Broadcast Hash Join (BHJ) is for small tables (no shuffle); Sort-Merge Join (SMJ) is for large tables (shuffle + sort).

SMJ involves three phases: Shuffle, Sort, and Merge. BHJ avoids shuffle by sending the small table to every node. Spark prefers SMJ for large joins because it's robust and spills to disk.