Re: Primary Keys vs. Unique Index

From: Tonyg246 <tonyg246_at_aol.com>
Date: 2 Jan 1995 21:38:17 -0500
Message-ID: <3eadap$n8k_at_newsbf02.news.aol.com>


In my opinion, I use the constraints whenever possible due to the ease of disabling/re-enabling.

However, it should be kept in mind that a UNIQUE index is not the same as a primary key constraint, as implied in the original note. A primary key uses a unique index for enforcement with an additional check for null values. On the otherhand, a unique index created via a 'create unique index' statement will
allow null values.

Tony Garciaserra Received on Tue Jan 03 1995 - 03:38:17 CET

Original text of this message