Question
In SQL Server, what is the defining effect of a clustered index on a rowstore table?
Select an option. Your answer will be checked instantly.
Correct Answer: B. It organizes the table’s data rows according to the clustered key
Explanation:
The clustered index determines the logical order of data pages by its key.
A table can have only one clustered organization at a time.
Leave a Reply