Marc Durdin's Blog

Thoughts on computing, Bible, cycling, family, my stories and more

Skip to content
  • Home
  • Computing
  • Cycling
  • Family|Bible|More

SQL server non-clustered indexes

January 20, 2009Computing, Development, SQLMarc Durdin

I learned something new today which on hindsight should be obvious: non-clustered indexes can be significantly faster for index scans than clustered indexes, because they can take up far fewer pages on disk, especially for tables with many fields. Read VRohr’s blog for details.

Post navigation

← Previous Post How to connect to a Netgear DG834G router in Windows 7 →

Recent Posts

  • The Case of the Sadly Real Currently Failing Test
  • Ancient Mysteries and Private Detectives
  • Creating and using an Internationalized Domain Name in July 2024
  • dynamic import on node.js with circular dependencies leads to interesting failure modes
  • What is marriage?

Archives

Recent Comments

  • Giro-Your-Strava updated to give Le Tour treatment to the climbs! | Marc Durdin's Blog on Giro-style elevation graphs for Strava
  • Windbg and Delphi – a quick reference | Marc Durdin's Blog on Another partial malware diagnosis
  • Windbg and Delphi – a quick reference | Marc Durdin's Blog on WinDBG and Delphi exceptions in x64
  • The Day Henry Broke the Internet – A Short Story – Part 2 | Marc Durdin's Blog on The Day Henry Broke the Internet – A Short Story – Part 1
  • Marc Durdin on The case of the terribly slow PayPal emails

Categories

  • (Temporarily password protected by request)
  • Bible
  • Bugs
  • Computing
  • Cycling
  • Delphi
  • Development
  • Family
  • Family|Bible|More
  • Griping
  • Hobart Bike Infrastructure
  • Hobart's Top Ten Climbs
  • JavaScript
  • Malware
  • mashups
  • Networking
  • Photos
  • PHP
  • Pontificating
  • silly ideas
  • SQL
  • Stories
  • Strava
  • Suggestions
  • Tools
  • Uncategorized
  • Unicode
  • Windows
  • Windows 7

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress