Defining Database Objects

A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.

Defining Database Objects

This section covers data definition language (DDL) in Greenplum Database
and how to create and manage database objects.

Creating objects in a Greenplum Database includes making up-front choices about
data distribution, storage options, data loading, and other Greenplum features that will affect the ongoing performance of your
database system. Understanding the options that are available and how the database will be
used will help you make the right decisions.

Most of the advanced Greenplum features are enabled with extensions to the SQL
CREATE DDL statements.