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: 16 or 32 columns for a composite key in Oracle8.0.4? Which is right?

Re: 16 or 32 columns for a composite key in Oracle8.0.4? Which is right?

From: <stan_herrman_at_my-deja.com>
Date: Tue, 20 Jul 1999 20:30:24 GMT
Message-ID: <7n2m91$7ij$1@nnrp1.deja.com>


Yuck!!!! Why would anybody want a PK or FK that had more than 16 columns??? Isn't this why surrogate PK's were thought of??? I'd put a UK on your concatenated columns that are the logical key, then use a number for the physical PK (and related FK's)...

Stan

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 20 1999 - 15:30:24 CDT

Original text of this message

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