What is a nonclustered index?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a nonclustered index?
Rating:
A nonclustered index has the same B-tree structure as the clustered index. The index consists of a root page, intermediate levels, and a leaf level. The leaf level of a nonclustered index does not contain the actual data. It contains pointers to the data that is stored in the data pages. A nonclustered index does not physically rearrange the data.
Rating:
Was this information helpful?
Other articles
- What is the simple recovery model?
- How to create a new table?
- What is a queue?
- Skills required for Microsoft test 70-431.
- What is the dbcreator fixed server role?