Answer
Delete in batches, drop partitions instead of deleting rows, or disable constraints if safe. This avoids long locks and table bloat.
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ