Indexes are the quick references for fast data retrieval of data from a database.
There are two different kinds of indexes.
1. Only one per table.
2. Faster to read than non clustered as data is physically stored in index order.
1. It can be used many times per table.
2. Quicker for insert and update operations than a clustered index.