Details
-
Improvement
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Fully Compatible
-
QO 2022-03-07, QO 2022-03-21
-
0
Description
We used to build DebugInfo in the callback function when we are to create a new Entry in the plan cache. After some refactoring in SERVER-59682 we are now constantly building DebugInfo before we are sure to create a new Entry to store in the plan cache. This change caused regression especially when the incoming queries share a same query shape.
This construction of a DebugInfo can be avoided if there already exists a same entry in the cache. Consider fallback to use a callback function to build the DebugInfo rather than construct it upfront.