Referring to the posts below,

What's the difference between a true composite key and the ones suggested in the links above (that is using unique indexes to implement a composite keys?


I think the difference is an index can either be unique or not, and a composite key is always unique.

Do you experience a problem with defining a unique index? 



Thank you Daniël for your input. No, i did not face a problem with defining a unique index. It is just that i came from the background of having a composite key and haven't tried using a unique index approach.