Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ Materialized View/ Full Materialized View/ Support and Constraints
Updated on 2023-10-23 GMT+08:00
View PDF
Share

Support and Constraints

Supported Scenarios

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

Unsupported Scenarios

  • Full 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 full 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 full 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.
Parent topic: Full Materialized View