Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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

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

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.

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.


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