Outdated This document is no longer maintained. Refer to the latest version.

Support and Constraints

Supported Scenarios

  • Supports the same query scope as the CREATE TABLE AS statement does.
  • Supports index creation in full materialized views.
  • Supports ANALYZE and EXPLAIN.

Unsupported Scenarios

Materialized views cannot be added, deleted, or modified. They support only query statements.

Feedback
    openGauss 2026-11-21 21:17:56
    cancel