Cluster Index and Non Cluster Index

Answer 1

This is a great question. A single clustered index can be created on a table and this index physically sorts the data for the entire table based on the values in this column. A table can have up to 255 nonclustered indexes. Nonclustered indexes are based on order of the data, but do not physically sort the data.

A table can have one of the following index configurations:

    * No indexes
    * A clustered index
    * A clustered index and many nonclustered indexes
    * A nonclustered index
    * Many nonclustered indexes