While running the above query (original) he is getting following error(ROACH CODE ERROR)
After modifying the query(modified query1) as follows
he is getting following error(ROACH ERROR log)
And finall when we make following change(modified query2)
we do not get an error , but query ran for 12 hrs + without completion .
Could you pls provide solution.
Thanks in adavance.