analytical function degrading the performance
I have a query which takes more than 3 hours .. the main fact table is written in a 3 level inner query.
In one sub query we use lag function with more than 20 columns as partition clause and same columns in order by of partiotion.
This is the bottle neck I see in explainplan as well as I query by pieces and stuck here.
How to deal with this scenario. Can a projection with the columns in analytical partition help me?