Thanks, Fred Williams and Patrick Smith for your help, I faced same issue, I have to delete around 2 years of data, I was trying month wise purging, when I started purging, it was taking 30 mins, after completed 5-6 month data, it took around 6-7 hrs, then I added Index and it was taking 10-15 mins.
Thank you very much.
Thanks,
Rajesh Gohil.