PBT verifying deterministic histogram cardinality estimates

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • 200
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      SERVER-108077 is a bug with non-determinism in histogram CE, causing plans to flip-flop as a result. We can introduce a PBT using our existing models (though we may only want to generate the data set once instead of per test case) and verify the property that all enumerated plans have the same CE (and cost) every time they are planned. Considerations - disabling the plan cache, using deterministic CE methods like histograms and sampling with internalQuerySamplingBySequentialScan enabled.

            Assignee:
            Matt Boros
            Reporter:
            Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: