The SET_MVREF_STATS_PARAMS procedure configures the collection level and retention period of materialized view refresh statistics.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
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 | Description |
|---|---|
| mv_name | The name of the materialized view.
|
| collection_level | The collection level of statistics. The default value is TYPICAL. Valid values:
|
| 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.
|