Create a script for comparing QO explanations

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

      The script should answer questions like:

      • Are the winning plans of two runs of the same query identical?
      • If multiplanner picks a different plan from cost-based ranker, 1) What is the cost estimate for the plan that multiplanner picked? 2) What is the number of works for the plan that cost-based ranker thinks is better?
      • Are the winning plans of two runs of the same query performance-wise equivalent (e.g. {a: 1} using index {a: 1} or {a:1, b: 1})?

      It would be nice if the script would also display explanations in a easier-to-compare form.

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

              Created:
              Updated: