Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is difference between Clusterd and non-clusterd index?

user-image
Question ajoutée par Qaisar Mushtaq , Senior Consultant , Systems Limitied
Date de publication: 2016/06/23
Usman Ajaz
par Usman Ajaz , TOS Administrator , DP World

Clustered Index

  • Only one per table
  • Faster to read than non clustered as data is physically stored in index order

Non Clustered Index

  • Can be used many times per table
  • Quicker for insert and update operations than a clustered inde

Utilisateur supprimé
par Utilisateur supprimé

Cluster index sorts the data with respect to the column on which it is applied, where as non-clustered index do not, it is just a logical sorting. Thus we can have only single clustered index and multiple non-clustered index on a table. Primary index on a table is clustered index. By default CREATE INDEX statement creates a non-clustered index

More Questions Like This