What are clustered and non-clustered Indexes?  

  RSS

Demon
(@demonguru)
Member Admin
Joined: 5 years  ago
Posts: 41
25/04/2018 1:00 am  
Clustered indexes is the index according to which data is physically stored on disk.Therefore, only one clustered index can be created on a given database table. Non-clustered indexes don’t define physical ordering of data, but logical ordering. Typically, a tree is created whose leaf point to disk records. B-Tree or B+ tree are used for this purpose.

DemonGuru18


ReplyQuote
Share: