The SET_MVREF_STATS_PARAMS statement is used to configure the collection level and data retention period for materialized view refresh statistics.
Syntax
PROCEDURE set_mvref_stats_params(
IN mv_name VARCHAR(65535),
IN collection_level VARCHAR(65535) DEFAULT NULL,
IN retention_period INT DEFAULT NULL);
Parameters
Parameter |
Note |
|---|---|
| mv_name | The name of the materialized view.
|
| collection_level | The collection level of statistics. The system default is TYPICAL. Valid values:
|
| retention_period | Specifies the number of days for which statistics are retained. The value range is from 1 to 365,000 days. Statistical records will be automatically deleted after the specified number of days. The system default is 31 days.
|