View vs. Materialized View in Oracle

  • 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
           CREATE MATERIALIZED VIEW View_Name
  • Oracle Syntax for creating View
           CREATE OR REPLACE VIEW View_Name

Newer Post Older Post

Leave a Reply

naeemgik. Powered by Blogger.