SQL statement suggestion
We are firing the below SQL statements on daily basis. We have to keep last 5 days customers records only in our database. Is there any other way the query can be rewritten, so that it will execute faster.
delete from ivr_unbilled_details_kl where (trunc(sysdate)-trunc(last_updated_date)) >=5
delete from ivr_unbilled_details_mh where (trunc(sysdate)-trunc(last_updated_date)) >=5
delete from ivr_unbilled_details_mp where (trunc(sysdate)-trunc(last_updated_date)) >=5
delete from ivr_unbilled_details_mu where (trunc(sysdate)-trunc(last_updated_date)) >=5
.
.
.
like 24 delete statements are in the SQL file.