SQL Server Performance Forum – Threads Archive

Index Types

Hi, Sql server will use different types of indexes like Clustered, Index Scan, Index Seek, Table Scan etc. I know a little about these idexes but I want to know what is the exact differences between them and which index will perform better. Can any one suggest articles which explain about the indexes? Thanks
Raj

http://www.sql-server-performance.com/optimizing_indexes.asp
http://www.sql-server-performance.com/sql_server_performance_audit7.asp
http://www.sql-server-performance.com/developers_tuning_tutorial.asp
http://www.sql-server-performance.com/clustered_indexes.asp
http://www.sql-server-performance.com/mr_indexing.asp You can also read more on indexes in BOL

You can also check in BOL->indexes..for more clarfications about indexes SURYA

Both the replies are valid and in addition to them below are some:
http://www.devx.com/getHelpOn/Article/10016
http://www.microsoft.com/technet/community/chats/trans/sql/sql0327.mspx
http://odetocode.com/Articles/70.aspx Fyi. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Couple of other links to read:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;325024
http://support.microsoft.com/default.aspx?scid=kb;EN-US;814324
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311826
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

thanks frank..very useful links.. SURYA

Cool links, thank you very much guys Raj

]]>