Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 26 Sep 2009 @ 19:05:56 GMT


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


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

  Yeah, I tried "WITH NO DATA AND STATISTICS" in v6.2.2, and it brought over zero'd stats. And in fact it didn't bring over the fact that some of them were sampled. So when I collected stats on the table, it collected full stats on the originally sampled columns. Oh well, p'haps that's a v6.2.2 feature.  


Interesting. So, the statement is already available in at least some of R6 releases? I opened, again, the R12 manual and scanned the pages listing restrictions and warnings associated with the statement. Can't find anything specific on sampled stats at all so this feature is going to be in the category of undocumented or hard-to-guess ones for at least some R6 and R12 versions.

Makes one wonder what else can be forgotten in the zeroed stats. I am sure Dieter will get an inspiration one day to run his stats scripts on the original table's stats and the stats collected on the copy table built with the WITH NO DATA AND STATISTICS statement and reveal the differences :-)


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