HomeMogDBMogDB StackUqbar
v2.0

Documentation:v2.0

Supported Versions:

REFRESH MATERIALIZED VIEW

Function

REFRESH MATERIALIZED VIEW completely replaces the content of a materialized view. Old content will be discarded.

Precautions

  • If WITH DATA is specified (or as the default value), the support query will be executed to provide new data. If WITH NO DATA is specified, no data will be created.
  • If you want data to be sorted when it is generated, use the ORDER BY clause in the supported query.

Syntax

RefreshMaterializedView ::= REFRESH MATERIALIZED VIEW mv_name [ WITH [ NO ] DATA ];

Parameter Description

  • mv_name

    Specifies the name of the materialized view to be refreshed.

Examples

-- Use the query in the definition of the materialized view order_summary to replace the content of the materialized view.
mogdb=# REFRESH MATERIALIZED VIEW order_summary;
Copyright © 2011-2024 www.enmotech.com All rights reserved.