Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 12 Oct 2005 @ 15:12:03 GMT


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


Subj:   Preserving table statistics across table DDL
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, October 12, 2005 11:10 -->

Scenario:
We altered the type of a column in a 5 bilion+ row table. The altered column is not used for joins or lookups.

We used the insert-select approach from "current" to "new", renaming "current" table to "old" and "new" table to "current".

Old/new table are same primary index to keep it amp local.


Question:
Is there a clever way to carry over the table statistics from the "old" table to the "new" one without having to recollect them?

The table is only loaded weekly so the stats would still be fresh.

Thanks



     
  <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: 27 Dec 2016