Today I went through some of the articles about the materialized view. In that article they mentioned that there are 3 types of MV Refresh Methods.
1) Force Refresh
2) Fast Refresh
3) Complete Refresh
These 3 types which are used while scheduling the Materialized view refesh.
Other that there are another method of refreshing which will be helpful when you are constantly changing the query of materialized view
On Demand Refresh – There is a oracle package which will help you to refresh the materialized view (DBMS_MVIEW.REFRSH)
We will explore about this package in upcoming blogs.
No comments:
Post a Comment