Creating Simple Materialized View and refresh it on hourly basis or if required on Demand
@Hi Team,
We have one requirement where we need to show few details on daily basis, to fetch these details during interface processing taking huge time. So to save interface time we are creating materialized view and we will get it refresh on hourly basis. So that Interface processing time will get reduced, presently we are facing issue in Creating materialized view which will get refresh on hourly basis. can you please provide some sample code for same. Also we want flexibility that we can refresh this view manually on demand as well before running the interface to get the latest data.
0