-
Type: Task
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Fully Compatible
-
QE 2021-10-04, QE 2021-10-18, QE 2021-11-01, QE 2021-11-15, QE 2021-11-29
-
141
NOTE There is ongoing work to create a new plan cache just for SBE plans. That work may affect what we decide to do here. The assignee of this ticket should ensure that the plan for the SBE plan caching project does not conflict with what we do under this ticket.
The plan cache will only store winning solutions for the "lower" part of a QSN tree (the result of multi planning). To build an execution tree from a cache entry, we will first have to graft the 'postMultiPlan' QSN tree onto the QSN tree of the winning plan.
This work will also involve modifying replanning code to only perform re-planning on portions of the tree that are multi-planned. There may also be some work to change the re-planning code to only use the number of reads done by the 'left' side of the query.