Subject | unique contrsaint vs unique index? |
---|---|
Author | Sándor Tamás |
Post date | 2010-07-29T14:02:40Z |
Hi,
here, with my collgues we had a conversation about the difference
between unique constraints and unique indices.
As we went through, we realized that we can use unique constraint for
foregin keys, but not unique index. The main question is: is there any
reason for both of them, and if not, then should we always use unique
constraint instead of unique index?
Thanks,
SanTa
[Non-text portions of this message have been removed]
here, with my collgues we had a conversation about the difference
between unique constraints and unique indices.
As we went through, we realized that we can use unique constraint for
foregin keys, but not unique index. The main question is: is there any
reason for both of them, and if not, then should we always use unique
constraint instead of unique index?
Thanks,
SanTa
[Non-text portions of this message have been removed]