
4.3 Types of Materialized Views 91
Chapter 4
4.3 Types of Materialized Views
The types of materialized views that can be created are essentially based on a
SQL code query. How many different variations of queries can be created?
Lots! Generally, materialized views are of the following basic formats:
Aggregates or filtering, or both aggregation and filtering
Joins
Set operator queries using operators such as UNION or INTERSECT
Nesting where one materialized view contains another materialized
view
Any combination of the above
4.3.1 Single Table Aggregations and Filtering
Materialized Views
This is a single table materialized view built using a query ...