Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Oct 2005 @ 22:34:12 GMT


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


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

<-- Anonymously Posted: Thursday, October 13, 2005 18:12 -->

1. If you don't want to recollect the stats then, just export ONLY statistics from TSET before renaming current to old and import it after renaming new to current.

2. Write a tool to query DBC tables and generate collect stats script, run this tool before renaming current to old and run the generated script after renaming new to current. But yes this will re-collect the stats.


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