Difference b/w clustered and non clustered index in sql server 2005?

Question

Satyanarayan Bajoria · Answer

Hi 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 Kumar · Answer

Hi 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.