Re: Newbie question
Date: Tue, 21 Jun 2005 10:39:12 +0200
In article <knndb1dp1sihupert9ik3ohu13rgsge885_at_4ax.com>,
> >Off the top of my head, the main
> >advantages of surrogate keys vs. natural keys are that they are stable
> >(I.e. they don't change),
> Why is this an advantage?
> But most natural keys don't change.
> > and they are never unknown.
> Most natural keys are never unknown.
> >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 keys. My point was simply "primary key != natural key"---or to elaborate: A primary key may be a natural key and vice versa, but not necessarily. And that surrogates are definitely "acceptable", and often/sometimes (YMMV) useful.
-- JonReceived on Tue Jun 21 2005 - 10:39:12 CEST