[dba-Tech] falsehoods programmers believe about names

[Jim Lawrence]

Hi Peter

That is why, in a database, I have never made a "name" the major key. IMO, names should be indexed for search purposes only, a soundex field can be helpful for handling strange name spelling variation and that is all. Student codes, SIN values, ZIP/postal codes and even phone numbers make better keys. 

Jim

----- Original Message -----
From: "peter brawley" <peter.brawley at earthlink.net>
To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com>
Sent: Monday, September 25, 2017 9:43:55 AM
Subject: [dba-Tech] falsehoods programmers believe about names

http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/

PB
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com