Support and Constraints

Supported Scenarios

  • Supports the same query scope as the CREATE TABLE AS statement does.
  • Supports index creation in complete-refresh materialized view.
  • Supports ANALYZE and EXPLAIN.

Unsupported Scenarios

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

Feedback
    openGauss 2026-05-12 20:38:15
    cancel