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

Orphan chunk skipping in COUNT_SCAN

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

      We can use orphan chunk skipping to make fast count (COUNT_SCAN) accurate in the presence of orphans, similar to what is done for distinct scans, but only in cases where the shard key is part of the index. (To do this more generally, i.e. completely fix SERVER-33753, we would have to push down FETCH into COUNT_SCAN as well, similar to what was done for distinct scans, and for any performance benefits we would want SERVER-94491).

      We would expect a performance improvement from this in the presence of many orphans (and therefore a more obvious fix in the actual count), but a small performance hit in the absence of orphans.

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

              Created:
              Updated: