Question 500
A stored procedure is fast for small tenants but slow after caching a plan optimized for a huge tenant. Which implementation step most directly addresses this requirement?
Explanation
Correct Answer
Parameter-sensitive plan reuse can degrade performance under skewed cardinalities. Use supported parameter-sensitive plan features or targeted query hints after benchmarking. Both tenant classes meet latency goals without global regressions.
Incorrect Answers
That change leaves the underlying defect unresolved: Parameter-sensitive reuse requires representative plan comparisons and supported optimizer mitigation.
The proposed implementation creates the wrong boundary because Statistics help estimates but do not always replace parameter-sensitive plan features or targeted query design.
This step would not produce the required behavior: Plan forcing is not universally adaptive; benchmark broad and narrow parameter classes and monitor change. This alternative omits a necessary contract or control and leaves the tested failure path open.