Reduce sample cardinality estimation overheads for single plan queries.

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

      Reduce the constant overhead of sample generation for sampling CE for queries with single solution plan.

      Per microbenchmarks we recognize that for queries that cannot use any indexes, with single plan solutions, the addition of optimizations such as CE cache and reducing the sample size through projection of fields has introduced overheads.

      This ticket should evaluate the cases where we can avoid performing these additional optimizations to reduce that overhead.

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

              Created:
              Updated: