Indexes in Sql server

Question

Hi Everyone,

 

Can anyone of you please post the detailed explanation of Indexes in SQL. ?

 

What is Indexes?

Types of Indexes?

Reasons why do we use indexes?

Advantages and Dis-advantages?

 

 

Regards,

Vamsi