Surrogate versus Natural Primary Keys
Friday, August 10th, 2007Warning: Random SQL related musings
I broadly agree with this article on primary keys in database design - in effect saying that autoincrement/serial/identity columns are a Bad Thing. There are some cases where I don’t think there is any realistic option though, and some cases where an artificial primary key is more pleasant.
Firstly, the effectiveness [...]