The secrets are in the execution plan. Here's a guided tour of the plan, and why things are going wrong for our query.