I asked a question last week.. but I am not sure I successfully put my idea across(http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26831283.html
I would like to re introduce the question, but this time I have added more sources.
Most documentation says to put the clustered index on the Primark Key....
However, after reading SQL Server 2008 Query Performance Tuning Distilled (Apress) page 118 it suggests putting a unique non-clustered index on the Primary Key.
This idea is also mentioned in SQL Server 2005 Performance Tuning (Wrox) page 234 and Inside Microsoft SQL Server 2005 Query Tuning and Optimization (Microsoft) 232.
Does anybody have any comments on not using the clustered index on an IDENTITY(1,1) INT Primary Key column?
I am using sql 2005/2008..... It would be also interesting if a different approach exists for other datase engines?
Here are a number of links which discuss the idea.
- See section beginning 'Avoid creating a clustered index based on an incrementing key'.