About the Pivotal Query Optimizer

In Greenplum Database 4.3.5.0 and later, the Pivotal Query Optimizer co-exists with the legacy query optimizer.

These sections describe the Pivotal Query Optimizer functionality and usage:

Overview of the Pivotal Query Optimizer
The Pivotal Query Optimizer extends the planning and optimization capabilities of the Greenplum Database legacy optimizer.
Enabling the Pivotal Query Optimizer
To enable Pivotal Query Optimizer, you set Greenplum Database server configuration parameters.
Considerations when Using the Pivotal Query Optimizer
To execute queries optimally with the Pivotal Query Optimizer, query criteria to consider.
Pivotal Query Optimizer Features and Enhancements
The Pivotal Query Optimizer includes enhancements for specific types of queries and operations:
Changed Behavior with the Pivotal Query Optimizer
There are changes to Greenplum Database behavior when Pivotal Query Optimizer is enabled.
Pivotal Query Optimizer Limitations
There are limitations in Greenplum Database 4.3.5.0 and later when the Pivotal Query Optimizer is enabled. The Pivotal Query Optimizer and the legacy query optimizer currently coexist in Greenplum Database 4.3.5.0 and later because the Pivotal Query Optimizer does not support all Greenplum Database features.
Determining the Query Optimizer that is Used
When the Pivotal Query Optimizer is enabled, you can determine if Greenplum Database is using the Pivotal Query Optimizer or is falling back to the legacy query optimizer.
About Uniform Multi-level Partitioned Tables

Parent topic: Querying Data