2.13 Managing Materialized Views
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.
- Creating a Materialized View
Create a materialized view using Object Browser. - Browsing a Materialized View
Select a materialized view from the Object Selection pane and view different reports about the materialized view. - Reports for Materialized Views
Alternative views available when viewing a materialized view in Object Browser. - Dropping a Materialized View
Select a materialized view from the Object Selection pane and click Drop.
See Also:
"Oracle Database Concepts" for information about materialized views
Parent topic: Managing Database Objects with Object Browser
2.13.1 Creating a Materialized View
Create a materialized view using Object Browser.
To create a materialized view:
See Also:
Parent topic: Managing Materialized Views
2.13.2 Browsing a Materialized View
Select a materialized view from the Object Selection pane and view different reports about the materialized view.
To view a materialized view:
Parent topic: Managing Materialized Views
2.13.3 Reports for Materialized Views
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
Parent topic: Managing Materialized Views
2.13.4 Dropping a Materialized View
Select a materialized view from the Object Selection pane and click Drop.
To drop a materialized view in Object Browser:
Parent topic: Managing Materialized Views