THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Query Optimizer » Execution Plans   (RSS)
  • The Query Optimizer and Cost Estimation

    Last year when I presented my session regarding the Query Optimizer at the PASS Summit and at a couple of local user groups, I was asked how the estimated CPU and I/O costs in an execution plan are calculated. Since Microsoft does not publish how these costs are calculated all I could say was that each operator cost depends on the operator ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on February 17, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement