Should I use Index or Unique Key for a non PK Uniqueidentifier?
Unique keys are indexes.  If your values are guaranteed to be unique, this is the best choice.


  Unique Key: Unique Key enforces uniqueness of the column on which they are defined. Unique Key creates a non-clustered index on the column. Unique Key allows only one NULL Value.