If the table is very big do a partition on them .Be careful in selecting the key column on which you want to create the partition table.
here you can have job split into 1/6 to 1/10 .
There can be option where in you can for truncate of a partition also.
Try them .




Reply With Quote