Interview Questions
1. What is Non-Cluster index?
A non-clustered index can be defined on a table or view with a clustered index or on a heap. Each index row in the non-clustered index contains the non-clustered key value and a row locator. This locator points to the data row in the clustered
index or heap having the key value. The rows in the index are stored in the order of the index key values, but the data rows are
not guaranteed to be in any particular order unless a clustered index is created on the table.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment