Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 Mar 2007 @ 09:25:39 GMT


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


Subj:   Partition Statistics
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, March 28, 2007 14:48 -->

I am trying to determine how to make use of the partition statistics feature. According to the Teradata user documentations, single-column partition does not need to collect separate partition statistics in addition to the partitioning column (if this column has individual column stats). Is it true that only multicolumn partitions will need to collect the partition stats?

I am also wondering if partition statistics is collected, will it still scan the full table even though new data is only inserted into the last partition.



     
  <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