scarydba.com
Adaptive Joins and Join Hints - Grant Fritchey
Adaptive Joins allow the optimizer to dynamically select joins as a query executes. What happens when you add a join hint to the equation?