This graphic shows how a materialized view can be created from detail tables.