Hi,

 

you can try modify your logic by adding IMPORT_ID to that table

and then you can import data without need to delete in the same time.

Then you can delete data in some portions during a day.

and successively run

 

 

SELECT COUNT(*) FROM THAT_TABLE

 

 

to clear old record versions.

 

This changed logic require changes in your current selects where you must include most recent IMPORT_ID.

 

regards,

Karol Bieniaszewski