zanhsieh

 Profile Answers by zanhsieh Questions by zanhsieh

• Apr 24th, 2006

 

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index, whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have 249 non-clustered indexes on a table.

vvijaychandra

 Profile 

• Jul 4th, 2006

 

Clustered Index:- A Clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table may have only one clustered index.Non-Clustered Index:- A Non-Clustered 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 in the disk. The leaf nodes of a non-clustered index does not consists of the data pages. instead the leaf node contains index rows.