Optimizing greenplum database design

posted Mar 12, 2014, 4:41 PM by Sachchida Ojha
Many performance issues can be improved by database design. Examine your database design and consider 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 datatype?
  5. Are your indexes being used?