Support and Constraints

Supported Scenarios

• Supports the same query scope as the CREATE TABLE AS statement does.
• Supports index creation in complete-refresh materialized views.
• Supports ANALYZE and EXPLAIN.
• Ustore does not support the creation and use of complete-refresh materialized views.

Unsupported Scenarios

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

Constraints

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.