Friday, May 2, 2014

What is the 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

Note: Only a member of this blog may post a comment.