The 11 Million is a standard number so it does not vary

I also run DBCC DBREINDEX on the table earlier

So question of defragmentation should not come up

DELETE I

FROM tbItem I (nolock)

INNER JOIN tbProductionOrder PO (nolock)

ON I.POID = PO.POID

WHERE PODescription LIKE '%00000%'

This will delete about 11000000 records

Once again this has been successfully severally