How to perform update/delete in materialized view
I have created an MV with complex logic involving large tables and aggregate functions.
As part of a new request, I need to update/delete certain records as well as change column data type.
How to achieve these 3 scenarios?
P.s: I am aware of workaround (creating a new base table and joining). Is there is anyway as easy as update/delete statement?