It takes less than 1 second when I run one query which has two UNION ALL.
But, when I use the same Query to insert the rows into a table, it takes too much of time and seems like it hangs. It does not come out. Then, I have kill the session.
I altered the table and made it LOGGING = NO to avoid Roll back segment and Redo operations.
I have to insert the queries rows in one temp. table in Pre-report trigger.
Total rows = 79000.
Is there any way to accelerate Insert operation?
Thanks in Adv.