«
»

Difference between Clustered and Non-Clustered Index

  • Clustered Index
    1. A clustered index is a special type of index that reorders the way records in the table are physically stored.
    2. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.
  • Non-Clustered Index
    1. 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.
    2. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

source

, , , ,

This entry was posted on Tuesday, April 13th, 2010 at 2:20 pm and is filed under Database, MS SQL Server, SQL Server 2008. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

  1. No comments yet.
(will not be published)
Submit Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Subscribe to comments feed
  1. No trackbacks yet.

SetPageWidth