We can apply
clustered index to a column which do not change or change very rarely
like primary key column where as we can apply non-clustered index to a
column which changes frequently.
We can have only one clustered index on a table where as we can have 249 non-clustered index on a table.
A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.
A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
Satyanarayan BajoriaPosted Dec 10, 2009, 5:37 AM
We can apply clustered index to a column which do not change or change very rarely like primary key column where as we can apply non-clustered index to a column which changes frequently.
We can have only one clustered index on a table where as we can have 249 non-clustered index on a table.
Gaurish KumarPosted Nov 10, 2009, 6:50 AM
Difference between these two are as below:
A clustered index is a special type of index that reorders the way records in the table are physically
stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain
the data pages.
A nonclustered index is a special type of index in which the logical order of the index does not match
the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of
the data pages. Instead, the leaf nodes contain index rows.