For tables that are not partitioned, think about using a CTAS to jot down the data you ought to keep within a desk instead of employing DELETE. If a CTAS takes the identical length of time, it's Significantly safer to operate as it has minimum transaction logging and might be canceled rapidly if wanted.Even though partitioning details may be produc