[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:
Depends
is depended on by SERVER-75732 Cache $lookup single solution inner q... Closed
Related
is related to SERVER-75506 Cache $lookup inner query plans with ... Closed
is related to SERVER-85595 [Classic] Cache single solution plans Closed
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?

Generated at Thu Feb 08 06:33:20 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.