What is execution plan caching and plan reuse behavior in SQL Server?

SQL Server caches execution plans to avoid recompilation overhead.

When a query executes, SQL Server compiles an execution plan and stores it in the plan cache. Subsequent executions reuse this plan if the query signature matches. Factors like parameterization, SET options, and schema changes influence reuse. Poor reuse leads to CPU overhead and plan cache pollution.