Query Execution Plans

You are a Architect on-call. A production issue might involve Query Execution Plans. How do you diagnose and mitigate?

Answers use simple, clear English.