Extend index-based cardinality estimator API to handle more scenarios

XMLWordPrintableJSON

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

      We will only pursue ideas on this list that provide more info about the feasibility of index-based CE, based on our initial findings from the perf/accuracy testing. We will re-run the perf/accuracy benchmarks to validate the below changes.

      • Extend API to handle index bounds specified in reverse order
      • Extend API to handle index bounds that are a union of single intervals & sum them. This would address CE for \$in
      • Extend to support index-CE in sub-planning

            Assignee:
            Unassigned
            Reporter:
            Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: