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(dot)klaver(at)aklaver(dot)com