Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-94491

Investigate using chunk skipping optimization for distinct scan + fetch

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 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).

            Assignee:
            Unassigned Unassigned
            Reporter:
            alya.berciu@mongodb.com Alya Berciu
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: