Greenplum database optimization - tips and tricks

There are couple of ways you can optimize the greenplum database. Bad performing queries may be the result of bad database design, improper distribution keys, badly written SQL and improper allocation of system resources. we will focus on