I'm going to add a clustered index to a fairly large table:
- over 7 million records
- 106 columns
- no PK
- no other indexes.
There is an
Id column which could potentially be used for the index key, but it's
not unique (although there are no duplicate values there).
I'm however reluctant to use it because of its datatype (performance impact) and have been thinking of adding an
int identity(1,1) column and use it as the clustered index key.
Which solution would you rather recommend? TIA