For tables that aren't partitioned, think about using a CTAS to write down the info you would like to hold within a desk as an alternative to using DELETE. If a CTAS normally takes the same amount of time, it's Considerably safer to operate as it has minimum transaction logging and might be canceled immediately if required.You can estimate the day