The PURGE_REFRESH_STATS procedure forces the automatic purge of materialized view refresh statistics that exceed the specified retention period.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
PROCEDURE purge_refresh_stats(
IN mv_name VARCHAR(65535),
IN retention_period INT);
Parameters
| Parameter | Description |
|---|---|
| mv_name | The name of the materialized view.
|
| retention_period | The statistics retention period, which ranges from 1 to 365,000 days. The default value is 31 days. The system automatically purges statistics that exceed the specified retention period.
|