The attached code needs to be built in to a materialized view for a discoverer report to access. I did not write the code but responsible now for engineering a solution. Can this code be broken in to multiple mv's and then combined? I have never done that. Or is there a better way to engineer this process.
Currently they create this view which is attached and then try to create a mv on top of it and since the view is executed and is poor in performance it takes four days to complete. I have added some indexing but still poor performance. I think the enitre process needs re engineered. I am open to any ideas. Thanks experts