Archives of the TeradataForum
Message Posted: Fri, 04 Feb 2011 @ 08:59:47 GMT
<-- Anonymously Posted: Friday, February 4, 2011 00:36 -->
I am having a table with 100 million records in a table with partition on a column. As part of daily extracts, I receive around 1.8 million records for UPDATES and 0.2 million for inserts. Now can I truncate a particular partition and insert all the 2 million records from my extract instead of Updating?
Eg: Lets assume we have a Table with one year data and a partition on date. Update to be performed to a particular month(eg:sept)
Instead of updating the records, can I use DELETE ALL to truncate the data from a particular partition and insert my data.
Any help would be much appreciated!!!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|