What is the difference between a clustered and a non-clustered index?
-
A
A clustered index is stored in memory; a non-clustered index is stored on disk
-
B
A clustered index determines the physical order of rows; a non-clustered index is a separate structure with pointers
-
C
Clustered indexes are for text columns; non-clustered are for numeric columns
-
D
There is no functional difference