I see this mistake a lot unfortunately. Using a hashed value based on a multiple column natural key as a primary key.

Algorithms used for hashing values are never guaranteed to...

The examples left out some very import points.

1.  "Filter Predicates in the WHERE statements".  If the client applications always use the SS# number to lookup information then they will ALWAYs...