This 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.