Performance Tuning   «Prev 

Using a materialized view

Using a materialized view

Location 1   The base table holds the basic information, which is transformed and loaded into the materialized view.
Location 2   A materialized view is formed from data that already exists in other tables.
Location 3   A user query against the materialized view, with the pre-computed results, is much faster than the same query against the base tables.