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 another materialized view.
• Cascading refreshing: When a nested materialized view is refreshed, automatic cascading refreshing is supported.
• Scheduled cascading refreshing: You can specify and modify the refreshing mode for periodically refreshed materialized views.
• Rewriting nested materialized views: Query statements can be automatically rewritten as SQL statements for querying materialized views.