View
|
Materialized
view
|
1.
In Views query result is not stored in the disk or database.
|
1. Materialized view allows to store
query result in disk or table.
|
2. When we create view using any
table, rowid of view is same as original table.
|
2. In case of Materialized view rowid
is different.
|
3.
In case of View we always get latest data.
|
3. Materialized view we need to
refresh the view for getting latest data.
|
4. In case of view we don't need
extra trigger or some automatic method to refresh the view.
|
4. In case of Materialized view we
need extra trigger or some automatic method so that we can keep Materialized view refreshed.
|
This blog will help you to know the basic of oracle DataBase and some important clause of Data Base Objects.
Sunday, 29 May 2016
Difference Between VIEW and Materialized View
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment