THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Performance » Hardware » cost based optimizer   (RSS)
Sorry, but there are no more tags available to filter with.
  • Table Scan - Aggregate Cost Structure

    In the previous post, I mention that in an earlier post on IO cost structure, that the cost of a table scan was approximately 1 CPU-micro sec per page, plus approximately 0.05 us per row for just a SELECT COUNT(*) This was calibrated on a 2-way Xeon 5430 Quad-Core 2.66GHz. I should also add that the test tables have a clustered primary key, with ...
    Posted to Joe Chang (Weblog) by jchang on February 27, 2009
Privacy Statement