
82
4.2
Materialized View Syntax
lations within partitions only, the situation might be quite different.
Once again, it is all about requirements.
The sequence by which materialized views are refreshed is highly sig-
nificant, because a materialized view can be created from another
materialized view—an aggregation of an aggregation. If a data ware-
house contains a large number of nested materialized views, all built
in a hierarchical structure of aggregations, this process could become
very complex and difficult to manage.
4.2 Materialized View Syntax
You now have a basic knowledge of materialized views, their benefits, and
their potential pitfalls. ...