-
Type: Improvement
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Fully Compatible
-
QO 2023-11-27, QO 2023-12-11
To aid in support cases and allow explain to convey information about the cached plan (since usually it is ignored), we should add an "isCached" field to all plans listed in explain. This will be a boolean to indicate whether the plan matches the cached plan.
For support cases where a bad plan is cached and the user runs explain and sees a different plan reported, the issue will be more obvious. We can also add a top level field "doesWinningPlanMatchCached" to surface this even higher.
- depends on
-
SERVER-82242 Implement QuerySolution hash and store in plan cache
- Closed
- related to
-
SERVER-16895 Users should be able to request that explain not bypass the plan cache
- Open