Hi,
I used normal bulk collect and for all insert with source and target as static tables it run for a few seconds but when I replace the source static table with a global temporary table it taking more than 1 hour .Both static and global temporary source table doesn't have indexes. Explain plan says Insert says Load Conventional and cost is 1. What could be the issue? Is the issue at session level or does global temporary table level? Please kind your advice
----------------------------------------------------------------------------------
| Id | Operation | Name | Cost |
---------------------------------------------------------------------------------
| 0 | INSERT STATEMENT | | 1 |
| 1 | LOAD TABLE CONVENTIONAL | TEMP_ABCD_EXEX_CASH_ABC_GRP| |
| 2 | SEQUENCE | SEQ_ABCD_EXEX_CASH_ABC_GRP| |