Although GPORCA is on by default, you can configure GPORCA usage at the system, database, session, or query level using the optimizer parameter. Refer to one of the following sections if you want to change the default behavior:

Parent topic:

Set the server configuration parameter optimizer for the Greenplum Database system.

  2. Restart Greenplum Database. This Greenplum Database gpstop utility command reloads the files of the master and segments without shutting down Greenplum Database.

Set the server configuration parameter optimizer for individual Greenplum databases with the ALTER DATABASE command. For example, this command enables GPORCA for the database test_db.

To set the parameter for a specific query, include the SET command prior to running the query.