For tables that aren't partitioned, consider using a CTAS to write down the info you want to preserve in a very table as opposed to working with DELETE. If a CTAS requires precisely the same length of time, it's Significantly safer to operate as it has minimal transaction logging and may be canceled promptly if desired.Performance optimization need