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. |
Saturday, 18 June 2011
What is the difference between view and materialized view ?
Labels:
Oracle FAQs
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment