Details
-
Type:
Task
-
Status: Closed
-
Priority:
Major - P3
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.1.0-rc0
-
Component/s: None
-
Labels:None
-
Backwards Compatibility:Fully Compatible
-
Sprint:QE 2021-08-23
Description
SBE will replan if the cached plan uses more works than the 'decisionReads'. See here. The classic engine only replans when the cached plan uses ~10x more works than expected. See here.
This could lead to scenarios where the query system repeatedly evicts cached plans when it isn't really necessary.