Check if you can do this with UNION ALL.
what i doubt is union checks for the both queries output and filter them so that no duplicate record is there and if your query returns lot of value couold be sorting is the issue.
If so you can set the increase PGA and run the query.




Reply With Quote