1

I am running this query to do massive deletion in my database. I am looking at Batchrequests/sec and it is quite low (like 15% of what my server can handle) Is there any way to rewrite this query to do more batchrequest/sec?

delete from Position 
Where MainFirmID = 26 and BatchID in (
       select BatchId from MyDB..Batch Where FirmId = 26
              and PeriodId <= 110 and PeriodId > 90
)

Thanks for your help.

  • RM
Hannah Vernon
  • 70,928
  • 22
  • 177
  • 323
user3618129
  • 91
  • 2
  • 8

0 Answers0