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