The PURGE_REFRESH_STATS statement is used to forcibly and automatically purge materialized view refresh statistics that exceed the specified retention period.
Syntax
PROCEDURE purge_refresh_stats(
IN mv_name VARCHAR(65535),
IN retention_period INT);
Parameters
Parameter |
Note |
|---|---|
| mv_name | The name of the materialized view.
|
| 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.
|