Question
What does a nonclustered index primarily contain?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Ordered key values with locators to the underlying table rows
Explanation:
A nonclustered index is a separate access structure from the table data.
It helps SQL Server locate qualifying rows without scanning the full table.
Leave a Reply