Saturday, 2 January 2016

Difference between view and materialized view.............

  VIEW :

  1. The view will not store any data.
  2. The view is mainly use for the security purpose.
  3. In view whenever the base table is dropped the view will not be accessible. 
  4. In view DML operation can perform.(on simple views)
MATERIALIZED VIEW :

  1. The materialized view will store the data.
  2. The materialized view is mainly use for the performance purpose.
  3. In materialized view whenever the base table is dropped the view will accessible.
  4. In materialized view DML operation can not perform. 












Please share your in case of any further clarification on above post.