Join Algorithms and Physical Storage

Describe how databases choose between nested-loop, hash, and merge join strategies.