Difference between View vs Materialized View

1) First difference between View and materialized view is that, In Views query result is not stored in the

disk or database but Materialized view allow to store query result in disk or table.

2) Another difference between View vs materialized view is that, when we create view using any table,

rowid of view is same as original table but in case of Materialized view rowid is different.

3) One more difference between View and materialized view in database is that, In case of View we

always get latest data but in case of Materialized view we need to refresh the view for getting latest

data.

4) Performance of View is less than Materialized view.

5) This is continuation of first difference between View and Materialized View, In case of view its only

the logical view of table no separate copy of table but in case of Materialized view we get physically

separate copy of table

6) Last difference between View vs Materialized View is that, In case of Materialized view we need extra

trigger or some automatic method so that we can keep MV refreshed, this is not required for views in

database.