Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 15 Apr 2002 @ 14:52:18 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Are updates generally slow in Teradata
From:   Claybourne L. Barrineau

If you have the disk space, try creating a temporary new table with the non-updated records and the new updated records (via bteq using the multi-insert syntax to avoid logging inserts into a table with existing records.) Delete all records from original table then insert new records from new temporary table into orignal table. Once validated, you can drop the temporary new table.

Hope this helps,

Claybourne Barrineau

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020