Is there any way by which we can first delete and then load the data in a table which has indexes by supressing the Index? or is there any other way by which this process can be made faster.
Per day we have around 30 lacs records to be deleted and inserted. The records keeps on grows from 1st day of the month till the end. On the first day they are minimum.
Do just if there is any way.
Thanks & Regards,
Vivek