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.
|
Thursday, 14 November 2013
Difference Between View And Materialized View
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment