This illustrates how materialized views work with the Summary Advisor.

• First, data is in a warehouse. The warehouse includes materialized views and workloads.
• From the warehouse, data goes to the trace log and the SQL cache.
• From the Trace Log, to Oracle Trace Manager, then to the Summary Advisor.
• From the SQL Cache, to the Summary Advisor.
• In addition, workload collection can go to the Summary Advisor.
• Also, Discoverer or a third-party tool can go to the Summary Advisor.