ExportXMLWordPrintableJSON

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

      In its initial implementation, the formula for the cost of an indexed nested loop join ignored the number of components the index has. This means that the plan enumerator cannot rely on the cost model to have enough resolution to distinguish between two INLJ plans using different indexes yet. The plan enumerator must use some heuristics to determine which index is best for now. Once this ticket is done, the plan enumerator should be able to avoid relying on this heuristic and instead the cost model to determine which index is best.

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

              Created:
              Updated: