Estimate the cardinality of index intersection/union nodes by combining their child conditions

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Unresolved
    • Priority: Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently given an index union or intersection, the CE of the node is estimated by applying exponential backoff to its children. This often results in very inaccurate estimates.

      Estimate the nodes by creating a compound condition from the intervals and expressions in their child nodes, and then estimate via sampling said expression.

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

              Created:
              Updated: