Login with  Log in with facebook
Hiring Manager? SIGN UP HERE

what is the difference between clustered and non- clustered index.

Rishi Yadav
09/13/2011 at 19:34
2 Answers

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.

Maneshwar Meel
09/14/2011 at 22:20


As same as above statemant also with non clustered index pointed RID which is created by combination of extent, pages and row offset (top of the pages) for that row.

Govind Agarwal
09/22/2011 at 20:10

If you want to post any answer to this forum then you need to log in.
Schedule a Demo

Schedule a Demo with us

Name *
Email *
Phone *
Company *