For tables that aren't partitioned, consider using a CTAS to write down the info you would like to hold in a table in lieu of utilizing DELETE. If a CTAS normally takes a similar amount of time, It truly is Significantly safer to run because it has negligible transaction logging and can be canceled speedily if desired.Requests and limitations which