Question
Why are INCLUDE columns added to a nonclustered index?
Select an option. Your answer will be checked instantly.
Correct Answer: A. To cover query output columns without enlarging the searchable key
Explanation:
Included columns are stored at the leaf level but are not part of key ordering.
They can eliminate lookups while avoiding wide composite keys.
Leave a Reply