A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. You can create, browse, drop a materialized view and view report.
Unlike an ordinary view, which does not take up any storage space or contain any data, a materialized view contains the rows resulting from a query against one or more base tables or views. A materialized view can be stored in the same database as its base tables or in a different database.
Materialized views are often used to improve performance, especially when storing data locally that is sourced from tables or views using a database link. Similarly, materialized views are often used instead of views when there are extensive calculations or summarizations, especially on particularly large data sets. Materialized views are refreshed at specified intervals which means the data is not always up-to-date but queries against them are significantly faster for the examples given above.
See Also:
"Oracle Database Concepts" for information about materialized views
Create a materialized view using Object Browser.
To create a materialized view:
See Also:
Select a materialized view from the Object Selection pane and view different reports about the materialized view.
To view a materialized view:
Alternative views available when viewing a materialized view in Object Browser.
Table 2-12 describes all available reports for materialized views.
Table 2-12 Available Reports for Materialized Views