Re: Primary Keys
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1995/05/08
Message-ID: <3olt77$rnb_at_sulawesi.lerc.nasa.gov>#1/1
Date: 1995/05/08
Message-ID: <3olt77$rnb_at_sulawesi.lerc.nasa.gov>#1/1
CREATE UNIQUE INDEX does just that. Using PRIMARY KEY will get you a defined primary key, which will CREATE a UNIQUE INDEX as well. Disabling a primary key removes the index (I think), re-enabling it will re-create the index (I think). Recent versions of Oracle allow index attributes to be specified (tablespace, granularity, name, etc.) as part of the primary key definition.
In your situation, either will suffice. Since they are similar, I'd recommend PRIMARY KEY. It makes the primary key obvious within the data dictionary. I know of no important advantages or disadvantages with regard to the use of a UNIQUE INDEX.
Regards,
Gary Received on Mon May 08 1995 - 00:00:00 CEST