If a query has suboptimal performance, the execution plan is the key tool for understanding the problem and supplying a solution.