For tables that are not partitioned, consider using a CTAS to write down the information you want to preserve in a very desk as opposed to working with DELETE. If a CTAS requires precisely the same amount of time, It truly is much safer to run because it has small transaction logging and can be canceled rapidly if essential.If you would like to vie