Quote:
Originally Posted by r937
you honestly prefer the surrogate key of my previous post, as compared with the natural key of this post?
|
Doesn't a surrogate key save a lot of work for the RDBMS, in cases where updating the natural key would cause cascade updates of a lot of dependent rows? Or is this performance issue negligible in practical use, given that you rarely udate a primary key?