[Join Optimization] Consider JoinEdge in cost model for INLJ

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

      Currently the INLJ cost model does not consider the join edge which it is satisfying. As part of the Mackery-Lohman formula, we need an estimate for the number of rows referenced by each index key as well as the number of unique keys. This information requires the cost model knowing the edge the INLJ is satisfying.

      This is also a prerequisite to SERVER-120616.

            Assignee:
            Ben Shteinfeld
            Reporter:
            Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: