Indexes are used in a table for fast retrieval of data while searching. Indexes works in the same way similar to a dictionary where finding a word is much more easier than compared to a normal book.
There are 2 types of indexes in SQL server
Clustered index – only 1 is allowed in a table.
Nonclustered index – SQL 2012 allows up to 999 nonclustered indexes in a table