Difference between clustered and non clustered index

Question

Accepted Answer

Clustered index determines the physical order of data in a table, while non-clustered index has a separate structure.

Clustered index sorts and stores the data rows in the table based on their key values, while non-clustered index has a separate structure that contains the key values and a pointer to the data row.
A table can have only one clustered index, while it can have multiple non-clustered indexes.
Clustered index is faster for retrieving large amounts of data, while non-clustered index is faster for retrieving small amounts of data or for searching on columns that are not part of the clustered index.
Example: A clustered index on a customer table can be based on the customer ID, while a non-clustered index can be based on the customer name.

Top Planetcast Software Engineer interview questions & answers