Optimizing Database Design

posted Oct 11, 2013, 8:21 AM by Sachchida Ojha   [ updated Oct 11, 2013, 8:28 AM ]
Many performance issues can be improved by database design. Review your database design and ask yourself the following: 
  1.  Does the schema reflect the way the data is accessed? 
  2.  Can larger tables be broken down into partitions? 
  3.  Are you using the smallest data type possible to store column values? 
  4.  Are columns used to join tables of the same data type? 
  5.  Are your indexes being used?