Defining QueriesGreenplum Database is based on the PostgreSQL implementation of the SQL standard.

Using Functions and OperatorsGreenplum Database evaluates functions and operators used in SQL expressions. Some functions and operators are only allowed to execute on the master since they could lead to inconsistencies in segment databases.

Query PerformanceGreenplum Database dynamically eliminates irrelevant partitions in a table and optimally allocates memory for different operators in a query.