What is Clustered & Non-Clustered Index?
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.
Saturday, April 14, 2012
Home
Unlabelled
What is Clustered & Non-Clustered Index?
What is Clustered & Non-Clustered Index?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment