Answer
Query Store keeps execution history, performance metrics, and helps detect regressions. It allows forcing stable plans.
Quick Answer
Query Store records query text, execution plans, and runtime stats (duration, CPU, I/O) historically. When a plan suddenly regresses (gets slow), you can compare it to the previous fast plan and force the good one back. Invaluable for diagnosing plan regressions after upgrades, stats updates, or data changes.
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