Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Clustered Index
Non Clustered Index
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