SQL Administrator Question:
Tell us 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 instead it contains pointers to the data pages. There can multiple non-clustered indexes on a single table.
In a Non-Clustered index, the leaf level pages does not contain data pages instead it contains pointers to the data pages. There can multiple non-clustered indexes on a single table.
| Previous Question | Next Question |
| Do you know what is SQL Server Browser? | Tell us what Is The Difference Between Lock, Block And Deadlock? |