This figure illustrates how summary management works.
First, data flows from an operational database to a staging file to the warehouse.
From the warehouse, you can use tools as well as perform daily maintenance for ETL.
You can use summary management on the materialized views.
Query rewrite uses both the details tables and the materialized views.