What is the difference between Cluster and Non cluster Index?

Posted by

To view Verified answers click on the button below.

A clustered index reorders the way records in the table are physically stored. There can
be only one clustered index per table. It make data retrieval faster.
A non clustered index does not alter the way it was stored but creates a complete
separate object within the table. As a result insert and update command will be faster.