Hi Team,
Can you please help in tunning the attached query as , i am trying to run this query and it runs for several hours and it did not give any output.
I am not able to generate the explain analyze plan as well and it keeps on running for several hours and did not give output.
I have attached the query and explain plan without analyze. Please help if nayone has any idea how to tune that query.
Regards,
Mukesh Kumar