Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Sep 2001 @ 15:06:05 GMT


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


Subj:   Stats
 
From:   Thopay Sudarsan

Hi all,

3.5M recs were multiloaded into a table which already had 80M recs. Stats were collected on all required columns . Then we found that values in couple of columns are incorrect. To fix it, I took the 3.5M in temp table, fixed it and the originally multiloaded recs were replaced with the updated recs. (No additional recs)

Question is, Do I have to Collect Stat on all the columns again or the existing stats are still good?


Thanks in advance

Sudarsan



     
  <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