December 2002
Intermediate to advanced
928 pages
85h 29m
English
A materialized view is a view that is used to speed up data warehouse queries with precalculated aggregates. The following views provide more information about materialized views in Oracle9i:
Lists information about existing materialized views.
Lists information about materialized view logs, which track changes to the master tables that can be used to refresh the materialized views.