Monday, 17 January 2011

Effective Clustered Indexes

For effective clustered indexes, follow the few basic points below.

  • Narrow – as narrow as possible, in terms of the number of bytes it stores
  • Unique – to avoid the need for SQL Server to add a "uniqueifier" to duplicate key values
  • Static – ideally, never updated
  • Ever-increasing – to avoid fragmentation and improve write performance

For full detailed explaination, read

No comments:

Post a Comment