Clustered Vs a non-clustered index

  • Each database table may have only one clustered index.
  • The leaf nodes of a clustered index contain the data pages.
  • The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

0 comments :

Post a Comment

> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger