Optimizing greenplum database design
Post date: Mar 12, 2014 11:41:44 PM
Many performance issues can be improved by database design. Examine your database design and consider the following:
Does the schema reflect the way the data is accessed?
Can larger tables be broken down into partitions?
Are you using the smallest data type possible to store column values?
Are columns used to join tables of the same datatype?
Are your indexes being used?