Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Feb 2001 @ 01:18:07 GMT


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


Subj:   Re: Collect Stat
 
From:   Eric J. Kohut

Mike,

In V2 R3, while you can submit a collect statistics on , I don't think it works like you've portrayed here. As I understand it (I could also be wrong) in V2 R3, when using the entire table option, the statistics are re-collected on each column or index that you had collected statistics on previously, but these are executed serially one at a time. So no time savings. This option is much easier.

In some release of V2 R4, I've heard that this will be done more efficiently but I don't know exactly when.

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.



     
  <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