I have this query DELETE r FROM PBRecord r WITH (ROWLOCK) WHERE r.pbRecordId = @MinId OPTION (RECOMPILE); it last 9 h !!. on powerfull server SQL server 2016 SP2 ,128 GB RAM
attached execution plan
please help me to reduce the time!
Thanks.,
Regards,
Hadrian