fast refresh of materialized view running slow
we do a refresh of the materialized view every day, and it usually took 15 minutes. However, today it took 3 hours.I done some research and saw this as a data issue. If the number of data changed since yesterday is huge, it would be like a completed refresh.
To see if this is true for our case, is there a way to query how many rows was refreshed yesterday?
thanks
To see if this is true for our case, is there a way to query how many rows was refreshed yesterday?
thanks
0