Difference between clustered and non clustered index in SQL

Question

Hi!!

Can someone tell me the difference between clustered and non-clustered index in SQL?

Answer 1

The differences between the clustered and non clustered index in SQL are :

1. A clustered index is used for easy retrieval of data from the database and its faster whereas reading from non clustered index is relatively slower.
2. Clustered index alters the way records are stored in a database as it sorts out rows by the column which is set to be clustered index whereas in a non clustered index, it does not alter the way it was stored but it creates a separate object within a table which points back to the original table rows after searching.

3. One table can only have one clustered index whereas it can have many non clustered index.