This simple SQL delete is running for ever to complete. It has only 200K rows to delete. It did delete fine in TEST but not in PROD.
delete FROM customer a WHERE exists ( SELECT x FROM purge_table b where a.customer_number = b.customer_number)
The explain plan is using the proper indexes on the customer_number. We've deleted all the child rows.