What Is The Difference Between Clustered And Non-clustered Index?

1.	What Is The Difference Between Clustered And Non-clustered Index?
Answer» In a clustered index, the LEAF level pages are the actual data pages of the table. When a clustered index is created on a table, the data pages are arranged ACCORDINGLY based on the clustered index key. There can only be one Clustered index on a table. In a Non-Clustered index, the leaf level pages does not contain data pages instread it contains pointers to the data pages. There can multiple non-clustered indexes on a SINGLE table.

Answer»

In a clustered index, the LEAF level pages are the actual data pages of the table. When a clustered index is created on a table, the data pages are arranged ACCORDINGLY based on the clustered index key. There can only be one Clustered index on a table.
In a Non-Clustered index, the leaf level pages does not contain data pages instread it contains pointers to the data pages. There can multiple non-clustered indexes on a SINGLE table.

Discussion