What is Clustered & Non-Clustered Index?

 Posted by Raja on 4/16/2008 | Category: Sql Server Interview questions | Views: 45168
Answer:

Clustered Index: Clustered index physically rearrange the data that users inserts in your tables. It is nothing but a dictionary type data where actual data remains.


Non-Clustered Index: It Non-Clustered Index contains pointers to the data that is stored in the data page. It is a kind of index backside of the book where you see only the reference of a kind of data.


| Alert Moderator 

Comments or Responses

Login to post response