1. The tables has no indexes at the time of load.
2. The create table and copy are in the same transaction.
So I guess that's pretty much it. I understand the long time it takes as some of the tables have 400+ million rows.
Also the env is a container and since this is currently a POC system , not much time has been invested in fine tuning it.
thanks all.
