Consider partitioning the table and alter table drop partition will address your issue