The REFRESH procedure refreshes the specified materialized view.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
PROCEDURE refresh(
IN mv_name VARCHAR(65535),
IN method VARCHAR(65535) DEFAULT NULL,
IN refresh_parallel INT DEFAULT 1);
Parameters
| Parameter | Description |
|---|---|
| mv_name | The name of the materialized view to be refreshed. |
| method | The refresh strategy for the materialized view. You can specify a default strategy when you create a materialized view. Valid values:
|
| refresh_parallel | The number of threads that execute the refresh operation at the same time. |