Cache cardinality estimates for re-use across different plans of the same query

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently when costing plans CBR requires calculating cardinality estimates for each MatchExpression, however there are predicates that are overlapping across plans.
      This ticket aims to take advantage of that by caching cardinality estimates and re-using them by evaluating MatchExpression equivalence.

            Assignee:
            Timour Katchaounov
            Reporter:
            Matt Olma
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: