Thursday, 14 November 2013

Difference Between View And Materialized View


View
Materialized view
A view has a logical existence. It does not contain data.
A materialized view has a physical existence.
Its not a database object.
It is a database object.
We cannot perform DML operation on view.
We can perform DML operation on materialized view.
When we do select * from view it will fetch the data from base table.
When we do select * from materialized view it will fetch the data from materialized view.
In view we cannot schedule to refresh.
In materialized view we can schedule to refresh.
We can keep aggregated data into materialized view. Materialized view can be created based on multiple tables.

No comments:

Post a Comment