What is SQL Server compiled plan vs execution plan difference?

Compiled plan is the optimizer’s chosen structure; execution plan is runtime instance with actual metrics.

The compiled plan is generated during optimization and stored in cache. It contains logical and physical operators. The actual execution plan shows runtime metrics like actual rows, CPU time, and spills. Differences between estimated and actual plans reveal cardinality estimation issues.