For tables that aren't partitioned, consider using a CTAS to jot down the data you want to retain within a table rather then employing DELETE. If a CTAS normally takes precisely the same length of time, It is much safer to run since it has nominal transaction logging and may be canceled promptly if needed.A one particular-time load to a small table