What is the difference between a clustered and a non-clustered index?

SQL Data Analyst Hard

SQL Data Analyst — Hard

What is the difference between a clustered and a non-clustered index?

Key points

  • Clustered index orders table data by key
  • Non-clustered index is a separate structure with pointers
  • Clustered index directly impacts table data order
  • Non-clustered index does not rearrange table data
  • Clustered index is more efficient for range queries

Ready to go further?

Start full exam Practice more questions

Related questions