Help Center> GaussDB> Distributed> Materialized View> Complete-Refresh Materialized View> Support and Constraints
Updated on 2024-05-20 GMT+08:00
View PDF

Support and Constraints

Supported Scenarios

  • Generally, the query scope supported by complete-refresh materialized views is the same as that supported by the CREATE TABLE AS statement.
  • The distribution column can be specified when a complete-refresh materialized view is created.
  • Indexes can be created in a complete-refresh materialized view.
  • ANALYZE and EXPLAIN are supported.

Unsupported Scenarios

  • Complete-refresh materialized views do not support node groups.
  • Materialized views cannot be added, deleted, or modified. Only query statements are supported.

Constraints

  • The base table used to create a complete-refresh materialized view must be defined on all DNs, and the node group to which the base table belongs must be an installation group.
  • When a complete-refresh materialized view is refreshed or deleted, a high-level lock is added to the base table. If the definition of a materialized view involves multiple tables, pay attention to the service logic to avoid deadlock.