-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
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.
- is depended on by
-
SERVER-75732 Cache $lookup single solution inner queries when sharded
- Closed
- is related to
-
SERVER-75506 Cache $lookup inner query plans with single solution
- Closed
-
SERVER-85595 [Classic] Cache single solution plans
- Closed