Unique indexing does not allow the field to have duplicate values if the column is unique indexed. This index can be applied automatically when primary key is defined.
Clustered Index.
Clustered index reorders the physical order of the table and search based on the key values. Each table can have only one clustered index.
NonClustered Index.
This type of Index does not alter the physical order of the table and maintains logical order of data. In this Each table can have 999 nonclustered indexes.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
There are three types of indexes -.
Unique Index.
Unique indexing does not allow the field to have duplicate values if the column is unique indexed. This index can be applied automatically when primary key is defined.
Clustered Index.
Clustered index reorders the physical order of the table and search based on the key values. Each table can have only one clustered index.
NonClustered Index.
This type of Index does not alter the physical order of the table and maintains logical order of data. In this Each table can have 999 nonclustered indexes.