-
Type: Improvement
-
Resolution: Won't Fix
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
QO 2024-02-05
In SERVER-75506, caching single solution queries on the inner side of a non-sharded $lookup lead to a positive performance impact. This could have a positive impact on sharded lookup as well, but some performance investigation should be done first.
For this ticket we should implement this change for sharded $lookup, analyze the perf impact, and make a decision about whether to commit it or not.
- depends on
-
SERVER-76684 Cached plans from inner $lookup single solution queries should be pinned
- Investigating
- is related to
-
SERVER-75294 Investigate slowness of sharded $lookup
- Closed