SQL Administrator Question:

Download Job Interview Questions and Answers PDF

Tell us what is the difference between Clustered and Non-Clustered Index?

SQL Administrator Interview Question
SQL Administrator Interview Question

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.

Download SQL Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know what is SQL Server Browser?Tell us what Is The Difference Between Lock, Block And Deadlock?