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

Estimate non-histogrammable types using heuristic selectivity

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 6.3.0-rc0
    • None
    • None
    • None
    • Query Optimization
    • Fully Compatible
    • QO 2023-01-09, QO 2023-01-23

    Description

      Currently, we estimate non-histogrammable types as the total count of values for that type (so any predicate matching an object will be estimated as the total count of objects). We can do better by instead estimating this as kDefaultSelectivity*numType (i.e. applying a heuristic estimate to the count for that type).

      Attachments

        Activity

          People

            alya.berciu@mongodb.com Alya Berciu
            alya.berciu@mongodb.com Alya Berciu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: