Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 09 Sep 2004 @ 21:16:17 GMT

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

Subj:   Re: Optimizing SQL
From:   Victor Sokovin

  Create a third table and change the update to populate the new table. When the load is complete rename the tables. Your workload is slowed down because of transient journaling. Insert to an empty table will be very quick. You also get a little insurance incase something is wrong with the update - you can roll back to the old table.  

I seem to remember from the original posting that the tables involved in the UPDATE were quite small, so, in my opinion, journaling should not be an issue in this case. I rather agree with other participants that the problem is in the syntax and its compatibility with the current release.



  <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: 15 Jun 2023