How should Execution Plans be used in production for SQL Server?

Compare estimated and actual rows, inspect warnings, memory grants, scans, seeks, joins, and spills, and validate improvements with runtime statistics.