Query Execution Plans

Give a real production-style example of using Query Execution Plans. Walk through the scenario end-to-end.

Answers use simple, clear English.