For tables that are not partitioned, consider using a CTAS to jot down the information you would like to maintain inside a table rather than employing DELETE. If a CTAS requires the same length of time, It can be A lot safer to operate because it has minimal transaction logging https://azure-cost-analysis41740.ltfblog.com/29742281/top-azure-cost-insight-and-report-secrets