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

  • Clustering key
  • Data duplication
  • Organization of data physically
  • Type of indexing
Clustered indexes dictate how data is physically organized in the database, arranging rows in the order of the clustered index key, while non-clustered indexes store a separate structure pointing to the data rows.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *