Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Sep 2009 @ 11:39:02 GMT


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


Subj:   Re: Update of millions of records
 
From:   Victor Sokovin

  Ex TD V12 code:  


  Create tableB as tableA with data and statistics,  


I checked the archives and it would appear that we have not yet discussed this on the Forum. In the documentation, the statement comes with a few pages of warnings and restrictions, which probably means that the scope of its usage is still testing environments.

Also, I understand that copying stats using this method is only possible if we copy the data at the same time. Moreover, all the rows in the table, or, else, the cardinalities of source and target tables would differ and copying of the stats in such cases would not work. Not the most economic way of doing this if data will have to be deleted afterwards.


Victor



     
  <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