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

[CQF] Fast estimation on _id

XMLWordPrintableJSON

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • Fully Compatible

      If we have a sargable node with an equality predicate on _id, do not ask CE framework for an estimate, instead assume cardinality is 1.

      Longer term, similar reasoning should apply for any fields which may be constrained to be unique.

            Assignee:
            jennifer.peshansky@mongodb.com Jennifer Peshansky (Inactive)
            Reporter:
            svilen.mihaylov@mongodb.com Svilen Mihaylov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: