[SERVER-76684] Cached plans from inner $lookup single solution queries should be pinned Created: 28/Apr/23 Updated: 23/Jan/24 |
|
| Status: | Open |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Matt Boros | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | quick-tech-debt | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||
| Assigned Teams: |
Query Optimization
|
||||||||||||||||||||
| Participants: | |||||||||||||||||||||
| Description |
|
Single solution queries should always pin their plan cache entry, so that they are not subject to replanning. It doesn't make sense to potentially replan these queries because we will never get a different result. For classic, the only single solution plans we cache are the inner $lookup queries. For SBE, we create cache entries for a broader set of single solution queries. This ticket can consolidate logic between SBE and classic for caching single solution queries. This should be done before SBE is enabled for the inner side of $lookup. |
| Comments |
| Comment by Matt Boros [ 02/May/23 ] |
|
I will probably be busy for the remainder of this sprint with the two projects I am currently on. After that I think I'll have time to take this. |
| Comment by Ana Meza [ 02/May/23 ] |
|
misha.tyulenev@mongodb.com , would Matt be available to work on this project sometime soon? |