Quote:
Originally Posted by Anna-J
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?
|
This in itself is a very minor issue, and not enough of a reason on its own to prefer surrogate keys to natural keys.