Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 01 Oct 2012 @ 10:53:24 GMT


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


Subj:   Re: How to do an collect stats on more than one
 
From:   Dave Wellman

Hi Vinod,

If you are on TD 13.10 or lower and there are no stats on those columns then you have to collect stats on the individual columns. If you have stats already collected then you can refresh stats using a single statement (COLLECT STATISTICS ON table-name).

If you are on TD14 then you can initially collect stats on multiple columns with a single statement. Look at the TD14 DDL manual for syntax.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 28 Jun 2020