SET_SYSTEM_DEFAULT

SET_SYSTEM_DEFAULT sets the system default value for the refresh statistics parameter.

Syntax

PROCEDURE set_system_default(
    IN     parameter_name         VARCHAR(65535),
    IN     value                  VARCHAR(65535));

Parameters

Parameter	Description
parameter_name	The name of the parameter, which can be set to one of the following values: COLLECTION_LEVEL: the level of statistics collection. The default value is TYPICAL. RETENTION_PERIOD: the number of days to retain statistics. The default value is 31 days.
value	When the parameter name is COLLECTION_LEVEL, the value can be set to one of the following values: NONE: do not collect statistics. TYPICAL: collect basic refresh statistics. ADVANCED: collect detailed refresh statistics. NULL: use the system default value, that is, TYPICAL. When the parameter name is RETENTION_PERIOD, the value specifies the number of days to retain statistics: 1 ~ 365000. NULL: use the system default value. -1: retain statistics permanently.