Re: Surrogate Keys
From: Jan Lenders <J.Lenders_at_Betuwe.net>
Date: Wed, 27 Sep 2000 09:10:49 GMT
Message-ID: <8qsdim$fr5$1_at_nnrp1.deja.com>
Date: Wed, 27 Sep 2000 09:10:49 GMT
Message-ID: <8qsdim$fr5$1_at_nnrp1.deja.com>
In article <8qrd0t$n9j$1_at_nnrp1.deja.com>,
dhussein_at_my-deja.com wrote:
> Hi,
>
> I need to know your opinion on using Surrogate
> Keys. Would you use them always? Only when needed?
> What are the pros and cons from your experience?
>
> Thanks in advance.
>
DO NOT use them always.
Surrogate keys can be used in a relational database;
- if there are no candidate keys. - if there are no candidate keys for which the value is 100% fixed. - ((if the inherited (foreign) primary keys no longer contribute todistincly identify an object.))
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Sep 27 2000 - 11:10:49 CEST