tag:blogger.com,1999:blog-8712770457197348465.post7023522596556366075..comments2024-03-29T00:43:22.798-07:00Comments on Javarevisited: Difference between Clustered Index and Non Clustered Index in SQL - Examplejavin paulhttp://www.blogger.com/profile/15028902221295732276noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8712770457197348465.post-91935836761806674582016-08-31T05:49:40.767-07:002016-08-31T05:49:40.767-07:00Thanks for the great article! Very helpful! Thanks for the great article! Very helpful! Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-28015962169610068582015-05-28T19:59:43.577-07:002015-05-28T19:59:43.577-07:00@Anonymous, SQL Server stores data in pages with s...@Anonymous, SQL Server stores data in pages with size of 8KB. Leaf node actually contains these pages in case of clustered index, but in case of nonclustered index they contain address of these pages. Columns which are used to build indexes also known as key are stored in different data structure. Gautamnoreply@blogger.comtag:blogger.com,1999:blog-8712770457197348465.post-73563845937203466842014-01-08T10:05:38.265-08:002014-01-08T10:05:38.265-08:00When you say that in clustered indices, leaves of ...When you say that in clustered indices, leaves of BST contain data, are those data whole records of a table, or just values of column(s) we've built clustered index on?Anonymousnoreply@blogger.com