Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Auto-incrementing primary key?

Re: Auto-incrementing primary key?

From: jared still <jkstill_at_teleport.com>
Date: 1998/01/23
Message-ID: <34c824dc.11388390@news.teleport.com>#1/1

On Tue, 20 Jan 1998 18:23:10 -0500, jeb <jeb_at_fayettevillenc.com> wrote:

>Reconsider the database design. Usually this type key is only used in
>improperly designed table structures...
>

Really? ;)

What about:

UIDs that may be updateable?

UIDs that propagate through several levels of relations resulting in unwieldy PK's and FK's?

Data redundancy introduced by intelligent keys?

Proper relational design also requires that the PK has no meaning. ( At least according to CJ Date ) Received on Fri Jan 23 1998 - 00:00:00 CST

Original text of this message

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