Please send your Questions & Answers or Feedback to "mohan@javabook.org"

What is the difference between clustered and a non-clustered index?


A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.
A Nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk.
Related Posts Plugin for WordPress, Blogger...
Flag Counter