A view is stored as a query in data dictionary. Whenever we execute that view, it takes data from base table using that query in data dictionary.

A materialised view along with query, it also store the results of the query in the database.
- A materialised view allow you to maintain copies of remote data on your local node.
- Materialized views, which store data based on remote tables are also, know as snapshots.
- After updation of base table materialized view data does not match with base table data. Data in materialized views must be refreshed to keep it synchronized with its base table.