• because a clustered index physically stores the records in that order, therefore as you can only store the data in one order you can only have one clustered index.

    Non clustered indexes store pointers in a seperate file location within the data file.