2
Reply

What is the basic difference between clustered and a non-clustered index?

Manu

Manu

Jul 13, 2006
12.9k
0



    Clustered index will be created implicitly when we have primary key column in the table.There we can have only one primary key. So There will be only one clustered index.

    Non clustered index should be created explicitly. There we can have up to 249 non clustered index as per sql server 2005 and 999 as per the sql server 2008.

    When compared with non clustered index, the clustered index will retrieve the result very quickly.Because the data will be stored on the same node of index key.
    But in non clustered index the data will be on the separate page of the memory location and node will have the reference page of the data.

    Senthilkumar
    August 07, 2009
    0

    I think th emost basic difference is:
    Clustered orders the table where as non-clustered does not.

    farshad
    August 14, 2006
    0