  20 Database Design Best Practices    • submit to reddit
Sam Lewis replied on Mon, 2012/11/05 - 3:21am  5. is not a good
practice, you should one way hash passwords not encrypt them.
8. is a bit Hungarian... why should I prefix bit columns and no
other columns?   Dean Pehrsson-c... replied on Mon, 2012/11/05 -
3:59am  "varchar column indexing will cause performance
problems"  On what RDBMS?  Fredrik Bertilsson replied on Tue,
2012/11/06 - 3:05am  6 and 7. Why only integer? Varchar is not
the only option to integer. Fix-length char is also an valid
option. Do you have anything to support the statement that
anything but integers would cause performance problems?  19. Why
would excessive joins give you worse performance?  Florin Manea
replied on Wed, 2012/11/07 - 6:47am in response to: Fredrik
Bertilsson  6 and 7: primary key value is used in indexes to
identify parent row in actual table so for varchar PKs index
storage requirements (and thus storage read effort to retrieve
data) will grow significantly