数据仓库服务 GAUSSDB(DWS)-ALTER MATERIALIZED VIEW:示例

时间:2025-02-26 16:12:43

示例

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

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

修改物化视图的表属性。

1
2
3
ALTER MATERIALIZED VIEW mv1 SET (force_rewrite_timeout=100);
ALTER MATERIALIZED VIEW mv1 SET ( mv_pck_column='col1');
ALTER MATERIALIZED VIEW mv1 SET (enable_foreign_table_query_rewrite = true);
support.huaweicloud.com/sqlreference-910-dws/dws_06_0358.html