Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Primary keys vs. unique indexes
Creating a primary key will also mean creating an index, but one that only
allow unique non-null values, the unique index constraint will permit both
unique values and NULL values.
Regards,
Kieran
-----Original Message-----
From: cemail_at_sprintmail.com [mailto:cemail_at_sprintmail.com]
Sent: 30 November 2000 06:00
To: Multiple recipients of list ORACLE-L
Subject: Primary keys vs. unique indexes
What is the difference between building a table and including the primary key versus building the table and then having creating a unique index on the same keys? When you create a table with a primary key, doesn't Oracle store it as an index anyway?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: cemail_at_sprintmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
http://www.marketplace.ie
Ireland's Home for eBusiness
![]() |
![]() |