Scenario:
What is the
difference between view and materialized view?
Solution:
|
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
Thank you :
- kareem