What is difference between normal view and materialzed view ?
Normal Views
* A view is simply the representation of a SQL statement that is stored in memory so that it can easily be re-used.
* Views have been used to hide the base tables that actually contain the data you are querying
* Ease in query parsing
Materialized views
Materialized views are schema objects that can be used to summarize pre compute replicate and distribute data
Difference between normal view and materialzed view :
* No physical memory used for views as it is just a definition stored in data dictionary
* A view do no derive the change made to it master table after the view is created.
* In materialized view we can not perform DML operation but the reverse is true in case of simple view.
To find more about materialized views Understanding materialized view in Oracle
