Search this site
GreenplumDBA Home
GreenplumDBA Members Club
GreenplumDBA LinkedIn Group
DBARef.com
Liability Disclaimer
Pivotal GPDB Documents
DBA Scripts Download - Members Only
Getting Started with Greenplum Database
Installing Greenplum Database
Configuring Greenplum Database
Securing your database
Allowing Connections to Greenplum Database
Securing Greenplum Database
MPP Data Models
Greenplum Database Quick Facts
Gpfdist
Set Database Environment
Set Environment variables and Path
Create Database
Create Roles (users and group roles)
Create Resource Queues
Granting Privilege and Role
Schema Development
Schema
Tables/
External Tables
Views
Functions
PSQL
Migrating to Greenplum
Oracle to Greenplum
PostgreSQL to Greenplum
Monitoring and Maintenance
gp_toolkit Schema
pg_catalog schema
Reporting
Sachi's AWR Report for Greenplum Database
Schema Size
Greenplum database performance tuning
Best practice
Tuning the environment
Tuning configuration parameters
Tuning SQL
Tuning data models
Greenplum database optimization - tips and tricks
>
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:
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 data type?
Are your indexes being used?
Comments