Thanks Aravind. We are following this approach and simplifying the complex unions.

Thanks all. Yes, you all are right, it has to do with the complex SQL. Our SQL is 2000+ lines of code with outer joins and Unions. Surprisingly when same SQL is execute on the other customer POD it is executing like charm. We are on Saas when raised SR we got the same standard answer , it is custom SQL and we need to tune…