Hi there,

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.