What is Clustered & Non-Clustered Index?

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

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