Answer
Excessive recompilation forces SQL Server to repeatedly rebuild execution plans, increasing CPU consumption and causing unpredictable performance. Causes include volatile schema, unstable statistics, and widely varying parameters.
Quick Answer
Recompilation forces SQL Server to rebuild an execution plan from scratch. Some recompilation is healthy (catching plan regressions). Excessive recompilation wastes CPU — each compilation takes time. Caused by: schema changes in temp tables, statistics updates, or using OPTION(RECOMPILE) on high-frequency queries.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ