Intermediate
SQL
Q57 / 100
What is the difference between a clustered index and a non-clustered index?
Correct! Well done.
Incorrect.
The correct answer is B) A clustered index determines the physical storage order of table rows (only one per table), while a non-clustered index is a separate structure that points back to the table data (multiple allowed)
B
Correct Answer
A clustered index determines the physical storage order of table rows (only one per table), while a non-clustered index is a separate structure that points back to the table data (multiple allowed)
Explanation
A clustered index defines the actual physical order of data rows in storage (a table can have only one), while non-clustered indexes maintain a separate sorted structure with pointers/references to the actual rows.
Progress
57/100