On 7/20/22 11:56, Ron wrote:
How will DELETE WHERE sales_id IN (...); , given that test_old has no index?Of course, we don't know if there's an index on sales.bill_date, since OP's only response has been another "tell me how to do it".
This awaits more information. At this point it is about the journey not the destination:)
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
