siddartha pal (9/21/2009)
The first index was created when primary key was created on ID column. So it means, instead of creating a new index, I just need to modify the existing index?Also the first index is unique clustered index and 2nd one is non-unique non-clustered index.
cheers
Siddarth
First, no, you don't need to modify the first index. Second, yes, the second index is declared as a non-unique index but it is by nature a unique index because it is define on the same column as the primary key which is also the first clustered index. As such, the second index will never have a duplicate value for ID.