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

[CQF] Refine Costing for Spool-based RIN

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • None
    • Query Optimization

    Description

      Currently we assign the group-level CE to all operators involved in the spool based RIN. Instead, for the inner distinct scans we should attempt to estimate the number of distinct values in order to allow costing to compute a more realistic plan cost. This can be some global heuristic (say 10% of the values are unique) or some simple function initially.

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            svilen.mihaylov@mongodb.com Svilen Mihaylov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: