ALTER MATERIALIZED VIEW

功能描述

修改物化视图属性。

该语法仅8.3.0及以上集群支持。

注意事项

无

语法格式

ALTER MATERIALIZED VIEW [ IF EXISTS ] { materialized_view_name }
    [ ENABLE | DISABLE ] QUERY REWRITE;
ALTER MATERIALIZED VIEW [ IF EXISTS ] { materialized_view_name }
    REFRESH [ COMPLETE ] [ ON DEMAND ] [ [ START WITH (timestamptz) ] | [ EVERY (interval) ] ];
ALTER MATERIALIZED VIEW { materialized_view_name }
    OWNER TO new_owner;

参数说明

• ENABLE | DISABLE QUERY REWRITE

  是否对本物化视图启动查询重写。

  在启用启用物化视图的查询重写后需刷新物化视图，保证物化视图数据是最新的。

• REFRESH [ COMPLETE ] [ ON DEMAND ] [ [ START WITH (timestamptz) ] | [EVERY (interval)] ]

  修改物化视图的刷新方式。

• OWNER TO new_owner

  修改物化视图的owner。

示例

启用物化视图的查询重写。

ALTER MATERIALIZED VIEW mv1 ENABLE QUERY REWRITE;
NOTICE:  REFRESH MATERIALIZED VIEW should be executed to enable query rewrite.
ALTER MATERIALIZED VIEW

相关链接

CREATE MATERIALIZED VIEW，DROP MATERIALIZED VIEW，REFRESH MATERIALIZED VIEW