Estimate non-histogrammable types using heuristic selectivity

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Fixed
    • Priority: Major - P3
    • 6.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • QO 2023-01-09, QO 2023-01-23
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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).

            Assignee:
            Alya Berciu
            Reporter:
            Alya Berciu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: