For tables that aren't partitioned, consider using a CTAS to jot down the information you want to hold in the table rather than using DELETE. If a CTAS can take the exact same period of time, it's much safer to run since it has negligible transaction logging and will be canceled immediately if required.Some queries, including pure scans, will see n… Read More