SET and RESET

Set and reset configuration options on the session.

Syntax

SET syntax:

SET config_option TO config_value

RESET syntax:

RESET config_option;

Parameters

• config_option: The configuration option to change.
• config_value: The value to set the option to.

Examples

Set the value of partitions (degree of plan parallelism) to a new value:

SET partitions TO 8;

= may be used in place of the TO keyword:

SET partitions TO 8;

Reset the value of partitions back to its default value.

RESET partitions;