What is the difference between clustered and non-clustered indexes?

Category: SQLWhat is the difference between clustered and non-clustered indexes?
Editor">Editor Staff asked 2 years ago

What is the difference between clustered and non-clustered indexes?

1 Answers
Editor">Editor Staff answered 2 years ago

The differences between the two are as follows:

  • One table can have only one clustered index but multiple non-clustered indexes.
  • Clustered indexes can be read rapidly rather than non-clustered indexes.
  • Clustered indexes store data physically in the table or view whereas, non-clustered indexes do not store data in the table as it has separate structure from the data row.