We need to perform a DELETE operation on various tables on a VLDB. What are your suggestions to optimize the delete process on huge tables?

[Freddy]

Hi, I'd like to ask you a quick question about the health field, we need to perform a delete operation on various tables on a vldb. what are your suggestions to optimize the delete process on huge tables? Please help me, Please kindly inform me as soon as possible.