SQL Server Performance Forum – Threads Archive
Cluster or NonCluster Index
Dear All: I am not a DBA in SQL Server but I use to be one in Informix that is why I need to ask if any of you recommend the use of clustered or non-clustered index as a general rule, I didn’t found any documentation about this, MS papers only provides some guidelines but I need to have a clear idea about the cost of a clustered index in a server versus a non-clustered index. Could you please give me some information or personal experience about this thing. Thanks in advanceThat brings many possibilities in SQL Server and you’ve plenty of information in this regard on thi website, for sample follow:
http://www.sql-server-performance.com/optimizing_indexes.asp
http://www.sql-server-performance.com/clustered_indexes.asp
http://www.sql-server-performance.com/index_tuning_wizard_tips.asp
http://www.sqlservercentral.com/col…ticesnotusingprimarykeysandclusteredindex.asp 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.
How do you define "cost"?
Anyway, see if this helps:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311826
http://support.microsoft.com/default.aspx?scid=kb;EN-US;814324
http://support.microsoft.com/default.aspx?scid=kb;EN-US;325024
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp
http://support.microsoft.com/default.aspx?scid=kb;EN-US;820209
—
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
]]>