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.
No comments:
Post a Comment