-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
SERVER-124126 disabled the CE cache when an IXSCAN plan has more than a threshold number of intervals, at which point the cost of converting the intervals to a MatchExpression and hashing it to check for a matching key in the CE cache outweighs the cost of performing cardinality estimation.
Since this fix only applies for plans with index bounds, investigate whether a similar issue exists for COLLSCAN filters being checked for/inserted into the CE cache.
See SERVER-108776 for examples of what the performance issues looked like with IXSCAN plans.
- is related to
-
SERVER-108776 Improve sampling CE performance in the presence of large $in lists
-
- Closed
-
-
SERVER-124126 Prevent CE caching above a threshold number of intervals in an index bounds set
-
- Closed
-