I am trying to optimize a query performance in Oracle that took around 40 – 50 secs, in some cases it took 1 min. After some analysis, I refactored code in the backend with C# and in the query, did something as follows: