Join optimization testing: check plan quality and optimality

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

      Given a set of queries in a workload, we want to be able to determine how the chosen winningPlans stack against all the other possible plans of the query. While we are not aiming for the winning plan to always be the best plan for a query, it should be among the best, or at least not among the worst possible plans.

      Please refer to the "Engineering Proposal: Testing Activities for Join Order Optimization" document for further discussion and implementation details.

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

              Created:
              Updated: