This is the delete statement iam executing.
DELETE FROM et_amend_rec_log WHERE rec_time < (SYSDATE - lv_log_days);
I am having index in rec_time column. Table is having 10 million rows matching the above condition. While deleting it is taking more than 5 hours.
1. Should I create something like bulk delete by putting in forall loop and commit for every 10 thousand rows?
2. Can I do something to make index usable?