Database Design

• Few things can overcome a poorly designed database
   
• Normalization and speed - can't we all just get along (or...who's afraid of a join or two?)
   
• Column ordering for the truly worried:
   
  • Not null, fixed-width
     
  • Some nulls, fixed-width
     
  • More nulls, fixed-width
     
  • Variable-width columns

Previous: Application vs Database         [Table of Contents]         Next: Query Tuning