When you delete data from tables using SQL DB2 in your programs, you should always use a condition in the DELETE statement, unless you want to delete all the rows from a table.

9 best practices for faster SQL queries Retrieve only the columns you need Use CASE instead of UPDATE for conditional column updates Keep large-table queries to a minimum Pre-stage your data ...