What is the difference between a Clustered and Non Clustered Index?
One table can only have only one clustered
index.
One table can only have many non-clustered indexes.
A clustered index requires no separate storage
than the table storage. It forces the rows to be stored sorted on the index
key.
A...