- Materialized views are disk based and update periodically based upon the query definition.
- The results of a view query are not stored anywhere on disk as they are virtual only and the view is recreated every time the query is executed.
- Materialized views are actual structures stored within the database and written to disk. They are updated based on the parameters defined when they are created.
- Materialized view- the underlying query result set has been saved to table
view - a query that pulls data from the underlying table - Unlike views, however, materialized views also store the results of the query in the database
Syntax:
- Oracle Syntax for creating Materialized View
- Oracle Syntax for creating View
CREATE OR REPLACE VIEW View_Name
No comments:
Post a Comment