Investigate using chunk skipping optimization with fetch

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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).

              Assignee:
              Unassigned
              Reporter:
              Alya Berciu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: