SET

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
   
   

Examples

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

See Also

UNSET