Help Center/
Data Warehouse Service /
Developer Guide/
Developer Guide (9.1.0.x)/
DWS Materialized Views/
Asynchronous Materialized Views/
Nested Materialized Views/
Overview
Updated on 2025-09-19 GMT+08:00
Overview
DWS materialized views support nested creation, refreshing, and rewriting. Using nested materialized views can simplify the process of defining a single view.
- Creating a nested materialized view: You can build a materialized view based on the materialized view.
- Cascading refresh: When refreshing a nested materialized view, not only the current view is refreshed, but automatic cascading refresh is also supported.
- Scheduled cascading refresh:You can specify and modify the refresh mode for periodically refreshed materialized views.
- Rewriting nested materialized views: Query statements can be automatically rewritten as SQL statements for querying materialized views.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot