Clustered index : physically  reorders the records
Non – Clustered Index: Logically  reorders the records
Composite Index: index on more than one columns

Thanks
Gurjinder Singh Brar
http://dotnet-question-answer.blogspot.com/

There are basically two types of indexes that we use with the SQL Server. Clustered and the Non-Clustered.