Use of serial# as Primary Key. (Experience DBA Advise Requested)
368861Nov 24 2007 — edited Nov 30 2007Sorry if question is out of the scoop of forum.
In my newly joined environment my seniors always use serial# as PK in every table every time & never use candidate key as PK. Doing so always left the candidate key as un-index, non-unique & null.
It produces many drawbacks I don’t have to point out all drawbacks as every experienced DBA knows that. I want the experienced DBA of this form to tell me the ways (any documents, generals) to convince my seniors to stop doing this.