Create a script for reproducing high query variance

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • 9.0 Required
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • Fully Compatible
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Create a script that will run unstable queries as many time as requested and collects the associated explanations. With that,

      • Count distinct number of plans that executed for a given query.
      • Show the average time for each distinct plan that was executed for a given query.

            Assignee:
            Andi Wang
            Reporter:
            Andi Wang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: