Re: Newbie question
Date: Tue, 21 Jun 2005 13:06:16 +0200
On Tue, 21 Jun 2005 10:39:12 +0200, Jon Heggland <heggland_at_idi.ntnu.no> wrote:
>> Why is this an advantage?
>Cheap answer: Because Oracle doesn't support ON UPDATE CASCADE. :)
It is cheap, indeed :)
>> Most natural keys are never unknown.
>It's hard to disagree with qualified statements like that, but as long
>as some natural keys may be unknown or inapplicable or whatever,
>surrogate keys have a use.
>> >Anyway, many "real-world" keys are really surrogates---SSNs, account
>> >numbers, registration numbers, student numbers and so on.
>> And that is a reason for not creating new surrogates.
>I'm not saying you should exclusively use surrogates and never natural
I am not saying the contrary. I think that we should not create surrogate keys whether we have good natural keys.
Trivially true :)
Regards Received on Tue Jun 21 2005 - 13:06:16 CEST