[dba-Tech] falsehoods programmers believe about names

Jim Lawrence accessd at shaw.ca
Tue Sep 26 14:20:45 CDT 2017

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. 


----- 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


dba-Tech mailing list
dba-Tech at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the dba-Tech mailing list