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.