Hi Experts-
We have a huge table (lets say T1) (Size: 330 GB, Number of Records: 1 Billion) which has been dropped and recreated recently to add and position the new columns in between (Which is not a good idea to do, however it has been done in that way as per the procedure).
On daily basis the data will be merged into this table (T1) from other source table (S1) which will usually run for 1.5 hours, after the table being dropped and recreated now the merge is running for 3 to 4 hours.
Will the drop and recreate would have created the time hike?
What will be impact of this scenario and could you please provide me some knowledge on what happens in the back end when we do this drop and recreate!
Thank you,
Pradeep