What are indexes in a Database. What are the types of indexes?

Indexes are the quick references for fast data retrieval of data from a database.

There are two different kinds of indexes.

Clustered Index
1. Only one per table.
2. Faster to read than non clustered as data is physically stored in index order.
Non­clustered Index
1. It can be used many times per table.
2. Quicker for insert and update operations than a clustered index.

Leave a comment

Your email address will not be published. Required fields are marked *