Index Types | SQL Server Performance Forums

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 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: Fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Couple of other links to read:;EN-US;325024;EN-US;814324;EN-US;311826
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?

thanks frank..very useful links.. SURYA
Cool links, thank you very much guys Raj