Join optimization testing: calculate cardinality of subplans

XMLWordPrintableJSON

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

      In order to figure out if the winning plan is optimal, we need to obtain the actual cardinality of any of the sub-joins.

       

      One way to do this is to reconstruct the sub-join from of its portion of the explain() and run it.

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

              Created:
              Updated: