If you have taken all due considerations and followed all performance recommendations and are still facing issues with DELETE, you might want to use utility tools for delete. MLOAD is the best option for this; the main reason is that MLOAD is more efficient than regular SQL delete:
- Less I/O as no TJ is required
- Uses less disk space and I/O
- Prevents lengthy rollbacks of aborted jobs
However, there are a few considerations when you use delete in MLOAD:
- As MLOAD DELETE does a full table scan, an equality of a UPI value is not permitted, but on NUPI this is allowed. But an inequality of a UPI value is permitted.
- Delete does ...
