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. |
posted by Jeyakumar @ Friday, December 02, 2011,
Post a Comment
Note: only a member of this blog may post a comment.