Subject unique constraint vs unique index
Author Nick Upson
what, if any, is the effective difference?

I recall that a unique constraint is enforced via an index so does it
ever matter which is used?