enable_nestloop

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

enable_nestloop

Enables or disables the use of nested-loop join plans by the legacy query optimizer
(planner). It's not possible to suppress nested-loop joins entirely, but turning this
variable off discourages the legacy optimizer from using one if there are other methods
available.