SQL Server Performance Forum – Threads Archive
Clustered Indexing !! Urgent!!!!!!!!!
Hi all,I need the answer to the following question Why should we not apply clustered index on Unique Primary Keys Please it’s very urgent
help me out Thanks Pramod Pramod Yadav
There you can find all you need: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_5h6b.asp Cheers
Is this an interview question? [<img src=’/community/emoticons/emotion-5.gif’ alt=’
‘ />]<br />Check out this site and the forum. Many related threads. But be aware that this is a kind of "It depends…" question.<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
And clusterd index is different to Clustering in SQL server, thread moved from Clustering forums. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:Why should we not apply clustered index on Unique Primary Keys?
Good question, why not? Who told you so?
it depends <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br />WBR, Vlad A. Scherbinin
]]>