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 » Internals » Performance » Indexes   (RSS)
  • SQL Server, Seeks, and Binary Search

    The following table summarizes the results from my last two blog entries, showing the CPU time used when performing 5 million clustered index seeks: In test 1, making the clustered index unique improved performance by around 40%. In test 2, making the same change reduced performance by around 70% (on 64-bit systems – more on that later).  ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 8, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement