According to search queries hitting @dbdebunk.com, too many data professionals question the mandatory nature of primary keys, ask about changes to them, or prefer surrogate to natural keys. This indicates misunderstanding and misuse of a critical feature that can wreak havoc with inferences made from databases, including analytics. I have explained one function of keys, but there are several types of key that are poorly understood.
Read it all (and please comment there, not here)
Do you like this post? Please link back to this article by copying one of the codes below.URL: HTML link code: BB (forum) link code: