Materialize View performance issue
We have created Materialize View with join if around 10 tables, we are doing complete refresh, it is talikng more than 2 hrs to refresh. But If I ran for one day, it is completing with in 2 seconds, Is there any way to do the Incremental refresh.
Thanks
Ram