What is difference between cluster and non cluster index?


Cluster Index:

  • A cluster index creates on primary key.
  • A cluster index create automatically when primary created on the table.
  • There can be only one¬†cluster index per table.
  • A cluster index sort and store data in a table based on columns included in index.
  • A cluster index takes space of table.

Non-Cluster Index:

  • There can be multiple non cluster index per table.
  • Non clustered indexes store both a value and a pointer to the actual row that holds that value.
  • A non cluster index takes space on the server.