Surrogate/Identies for all keys
From: JRStern <JRStern_at_gte.net>
Date: Wed, 07 Feb 2001 18:54:14 GMT
Message-ID: <3a81996a.9264091_at_news.gte.net>
Date: Wed, 07 Feb 2001 18:54:14 GMT
Message-ID: <3a81996a.9264091_at_news.gte.net>
I went to a presentation the other day, the speaker suggested she
always uses surrogate/integer/identity keys -- always!
This seems to be an *increasingly* common practice, with some
variations using UIDs or other non-significant surrogates.
I know Joe Celko disapproves, and I find myself in complete agreement
with what I've read from him on this subject. But, are we a couple of
old fogies, when all the kids are using surrogate/identities all the
time?
PS -- I know all of the technical arguments pro and con, I'm really asking more for a show of hands as to who does what, and secondarily about the sociology of the choice.
Joshua Stern
JRStern_at_gte.net
Received on Wed Feb 07 2001 - 19:54:14 CET