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=’
![Wink ;) ;)](styles/default/xenforo/smilies/wink.png)
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=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
]]>