Verify index seek cost

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      The cost model cannot account for seek cost properly at this time since we do not have an estimate for the number of seeks from CE. There is followup work for this, but in the meantime we should verify that the seek cost we got from calibration is reasonable.

        1. Cost estimate vs execution time.png
          Cost estimate vs execution time.png
          16 kB

            Assignee:
            Militsa Sotirova
            Reporter:
            Militsa Sotirova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: