Hello, my portlet query is very complex with lots of INNER and OUTER JOINS and its pulling a lot of data which takes up forever to run.
I would like to run my portlet on top of a materialized view to fasten the processing time.
Since I never did this before, I am looking for some guidance from senior members.
Here are some of the @SELECT statements. How would I access these thru a view and how complex is this process?
If you could provide an example, it would be great.