SET

Owned by Boaz Raufman
Apr 02, 2023
1 min read

Sets a value of a parameter. 

Syntax

SET [SESSION|GLOBAL] parameter-name=value;

Description

The value can be set at either the session or the global level. 

Setting at session level is valid only during the current session's lifetime; setting at global level is persistent and affects the entire system by becoming the default value for all new sessions. 
If set level is not specified, session level is assumed. 

Hierarchy of the parameters value levels (top override lower levels):

  1. Session level setting
  2. Local setting (through the local-conf.ini file)
  3. Global level setting
  4. Default value

To reset a parameter to its default value, use the UNSET command.

Examples

set adaptive.cache.query.enable=1;
set global dynamic.aggregation.auto.generate.enable=1;

See Also

UNSET