Add ability to use histograms to estimate residual predicates

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • QO 2024-11-25
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      We can encounter sargable predicates that are not expressed as index bounds but as MatchExpressions. Assuming the leaf expressions reference paths which have corresponding histograms, we can use them to generate cardinality estimates.

            Assignee:
            Ben Shteinfeld
            Reporter:
            Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: