balaji jadav
What is the basic difference between clustered and a non-clustered index?
By balaji jadav in SQL Language on Oct 31 2014
  • Pankaj  Kumar Choudhary
    Mar, 2015 29

    clustered index arrange data in physical order while non clustered index arrange data in logical order. in a table we have only one clustered index but we can hav more then one non clustered index clustered index contain a key and row data while non clustered index contain key and a pointer to row we can create clu index on single column but we can create non clus index on multiple columnclustered index is use when column value are unique but it is not necessary in non clus index

    • 1
  • Manish singh
    Dec, 2014 17

    Clustered index arranged in physically order, while Non-clustered index arranged in logical order only one clustered index reside in table, while More than one Non-clustered index reside in table. clustered index implement on only one column in table , but non clustered index can implement on one column or combitination of more than one column in table.

    • 0
  • Manish singh
    Dec, 2014 17

    Clustered index arranged in physically order, while Non-clustered index arranged in logical order only one clustered index reside in table, while More than one Non-clustered index reside in table. clustered index implement on only one column in table , but non clustered index can implement on one column or combitination of more than one column in table.

    • 0
  • Vikram Agrawal
    Dec, 2014 8

    clustered index arranges the data physically whereas Non Clustered index arrange the data logically. that's why Clustered index can be only one in a table while Non-Clustered index might be more than one.

    • 0
  • balaji jadav
    Oct, 2014 31

    Clustered indexes sort and store the data rows in the table or view based on their key values.A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value.Source : http://msdn.microsoft.com/en-IN/library/ms190457.aspx

    • 0