For tables that are not partitioned, consider using a CTAS to put in writing the info you would like to hold in a table in lieu of using DELETE. If a CTAS will take the exact same amount of time, It really is Substantially safer to operate since it has nominal transaction logging and will be canceled swiftly if essential.For tables with below 60 mi