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

Posted by Prem Tiwari | Updated on

Indexes are the quick references for fast data retrieval of data from a database. There are two different kinds of indexes.

What are the types of indexes?

1. Clustered Index

  1. Only one per table.
  2. Faster to read than non clustered as data is physically stored in index order.

2. Non­clustered Index

  1. Can be used many times per table.
  2. Quicker for insert and update operations than a clustered index.

If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

Related Questions & Answers