What are the types of indexes?

Clustered indexes : All the rows will be stored in the order of the primary key. There can be only one clustered index per table.
Non-clustered indexes : All the columns which are not primary key can be define as non clustered index and they are stored as B-tree structure with the leaf level nodes having the index key value.

What are the types of indexes? was last modified: October 1st, 2017 by Justin Antony

About Justin Antony


Leave a Reply