[CQF] Consider the number of projections produced by a PhysicalScan when determining its cost

XMLWordPrintableJSON

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

      Currently the cost of a PhysicalScan node (and Seek and IndexScan) is a function of its cardinality estimate and startup/marginal cost coefficients. It ignores the number of projections it must produce. This leads to plans that incorrectly have identical costs according to the cost model, but in reality have different runtimes.

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: