-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
We can't use the chunk skipping optimization in distinct scan when there is a fetch stage even if the index includes all the information we need about the shard key, because fetch must necessarily happen before we shard-filter. However, if we delegate shard-filtering logic to the chunk skipper, we may be able to skip to the next chunk without fetching at all (and also avoid falling back to a sequential scan of orphans in case of a fetch being present).
- depends on
-
SERVER-94492 Shard-filter distinct scan using only the orphan chunk skipper
- Open
-
SERVER-92465 Implement skipping orphan chunks in distinct scan
- Closed