Archives of the TeradataForum
Message Posted: Tue, 05 Mar 2013 @ 13:39:03 GMT
The customer is trying to delete various months / weeks / days of transaction data off a transaction table with PPI set up with transaction date, ?which method suits the best performance if we are deleting a segement of data (e.g. if we are maintaining history for 3 years, so every day / month, we will delete off the data that is older than 3 years)?
1. Drop range on PPI
2. Delete from
3. Create a temporary table, insert into temporary table with transaction_date >= specified date range, delete the table, rename the temporary table to target table name
Which one of the 3 will be a proper practice for fastest performance, and the drawl back?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|