Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Primary Keys

RE: Primary Keys

From: Brian Wisniewski <>
Date: Thu, 01 Feb 2001 13:04:06 -0800
Message-ID: <>

I don't know if my prior email made it out to the list or not.

In 99% of the rows the Primary key will be a combination of 2 fields however they cannot be 100% sure this concatenated key will always be unique therefore the need for the surrogate key.

>From what I've gathered the PK will usually be columns 1 and 2 but at
other times it will be 2 and 3 and somehow they've got this all figured out.

It is possible if I add the date field to the other two fields it will always be a unique key but I need to talk to those who are familiar with the data to discuss.

They just wanted me to come in and set up Oracle, fail safe, backup and recovery, partitioning, database layout etc.

The question about the need for the PK was just something that came up and I didn't see a need for it based upon how they will be storing and querying data. They will never be querying off of the surrogate key, the table won't be partitioned off of it, there are no children tables hanging off of this, no snapshots, etc.

Get personalized email addresses from Yahoo! Mail - only $35 a year!
Please see the official ORACLE-L FAQ:
Author: Brian Wisniewski

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: (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).
Received on Thu Feb 01 2001 - 15:04:06 CST

Original text of this message