This content has been marked as final. Show 3 replies
Thanks for your reply.
From your post i guess your target DB table is empty. In that case i would suggest you create index and gather statistics once the data load is done.
Yes am loading the data into empty table.
What would be technical difference creating index before and after the data load.
Thanks & Regards
It is basically the difference between DML and DDL. DDL are faster than DML. This is because the DDL does not have to deal with UNDO details.
If there is an index in a table and you insert into the table then an insert into the index will also happen which is a DML. But if you create the index after the data is loaded the index creation is a DDL and would be much faster.