Join Optimization testing: Validate cost model with complex queries

XMLWordPrintableJSON

    • 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

      Once we have a randomized query workload, we can do the following:

      • chart estimated cost vs. actual execution time, to confirm that the estimated cost has at least some correlation to the actual execution time
      • calculate a global correlation coefficient and track it over time so that future changes to the cost model do not result in regressions in this particular correlation

      Please refer to the "Engineering Proposal: Testing Activities for Join Order Optimization" for more information.

            Assignee:
            Unassigned
            Reporter:
            Philip Stoev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: