• Home
  • primarykey2000 Answers

Answered Questions

  • Oct 17 2006
    03:17 PM
    28052
    16

    Difference between Cluster and Non-cluster index?
    • bsush

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: Sushant

    • Oct 25th, 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 as many non-clustered indexes as we can on the db.

    Sameer

    • Nov 1st, 2012

    Now SQL SERVER 2008 onwards we can have 1 cluster index and 999 non cluster index on one table.