Subject | Re: [firebird-support] Unique vs Index... |
---|---|
Author | Ann W. Harrison |
Post date | 2004-12-17T20:35:32Z |
At 02:45 PM 12/17/2004, Chad Z. Hower aka Kudzu wrote:
major difference between a unique constraint and a unique index
is that you can use a field - or list of fields - that are the
subject of a unique constraint as the referenced (aka parent)
in a foreign key relationship.
Regards,
Ann
>Im sure this has been asked a billion times.. Is there a FAQ or article onA unique constraint creates an index to enforce uniqueness. The
>this? I want to reasearch it in full - but my primary question is:
>
>Will unique require less storage space?
major difference between a unique constraint and a unique index
is that you can use a field - or list of fields - that are the
subject of a unique constraint as the referenced (aka parent)
in a foreign key relationship.
Regards,
Ann