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.
|
Friday, May 2, 2014
What is the difference between view and materialized view?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.