Re: Is the use of VARCHAR(256) as Primary Keys preferred in Oracle?

From: Pablo Sanchez <pablo_at_dev.null>
Date: Mon, 18 Nov 2002 06:33:43 GMT
Message-ID: <Xns92C9EFAF939C3pingottpingottbah@209.242.64.107>

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in news:8o%B9.73293$1O2.5806 @sccrnsc04:

> a surrogate key is an arbitrary key (eg a sequence). A natural key is one
> that is naturally part of the data (eg in the US the social security number
> for people)

As a side note, SSN's are intended to be unique but are not for a variety of reasons.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Mon Nov 18 2002 - 00:33:43 CST

This message: [ Message body ]
Next message: Jan Gelbrich: "Re: broad discussion about future market direction for DBA"
Previous message: Rx: "Re: two snapshots for the same master table"
In reply to: Jim Kennedy: "Re: Is the use of VARCHAR(256) as Primary Keys preferred in Oracle?"
Next in thread: Niall Litchfield: "Re: Is the use of VARCHAR(256) as Primary Keys preferred in Oracle?"
Reply: Niall Litchfield: "Re: Is the use of VARCHAR(256) as Primary Keys preferred in Oracle?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US