>In that case there's another general approach possible. If you need to retain 30 days' worth of hits, you could use 32 separate hits tables:

Good idea but the range may vary.

For now, I delete in batch of 2000 records. This is faster. I will have the exact metrics once I restore a new backup on UAT with the full load of data.