-
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
When checking if a document satisfies a set of IndexBounds, we first extract all the index keys, then for each one we check if each component is in corresponding OrderedIntervalList for that field. This check currently iterates over all the intervals in order. Instead, we can perform a binary search as we know the OrderIntervalList is sorted. This may help improve the sampling time for large indexed $in queries.
- is related to
-
SERVER-108776 Improve sampling CE performance in the presence of large $in lists
-
- Needs Scheduling
-