Explain Nested Loops, Merge Join, and Hash Join with when each is chosen.

Quick Answer Nested Loops: iterate outer rows, seek matching inner rows via index — best when outer set is small. Merge Join: both inputs must be pre-sorted; scan both simultaneously — fast when indexes provide sort order. Hash Match: build a hash table from smaller input, probe with larger — chosen when sorts aren't available and data is large.