Mr_Shaw
asked on
unique nonclustered index on the primary key.
The book SQL Server 2008 Query Performance Tuning Distilled (Page 118) suggests using unique nonclustered index on the primary key.
I have never thought of doing this...
From what I have read this sound a good idea, but the following link says this will effect DAO and ADO.
here is the link:
http://bytes.com/topic/sql-server/answers/81459-why-cluster-primary-key
Does anybody have any comments?
I have never thought of doing this...
From what I have read this sound a good idea, but the following link says this will effect DAO and ADO.
here is the link:
http://bytes.com/topic/sql-server/answers/81459-why-cluster-primary-key
Does anybody have any comments?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
It depends. It's pretty arbitrary to say the primary key should/should not be clustered without knowing what that key is and how it is used. DAO / ADO? Does anyone really still use those? :)
>>It's pretty arbitrary to say the primary key should/should not be clustered without knowing what that key is and how it is used. <<
Absolutely.
>>DAO / ADO? Does anyone really still use those?<<
It is quite amazing how long they have lasted.
Absolutely.
>>DAO / ADO? Does anyone really still use those?<<
It is quite amazing how long they have lasted.
ASKER
The where clause could change depending what query is run.