Home -> Usenet -> comp.databases.oracle -> Re: Primary Keys

Re: Primary Keys

From: pconnors on BIX <pconnors_at_BIX.com>
Date: 1995/04/13
Message-ID: <pconnors.797748419_at_BIX.com>#1/1 







DPWCC02.OBERLE02_at_SSW.ALCOA.COM (Oberle, John F.) writes:



>Can someone tell me the significance of the primary key 

>constraint.  What are the advantages or disadvantages over 

>creating unique indexes.

 


>Thanks in advance;

 


>John F. Oberle





They are pretty much the same under the hood.



The primary key constraint creates a unique index, but it 
uses a system-generated name and defaults the storage and
tablespace. For that reason, our shop is putting a standard 
in place that constraints are to have the index name 
and storage info created explicitly.
Received on Thu Apr 13 1995 - 00:00:00 CEST












Original text of this message