Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Jan 2012 @ 14:38:10 GMT


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


Subj:   Re: Generate collect statistics statement
 
From:   Dave Wellman

Hi James,

1) Almost certainly this is a simlar situation.

2) BE AWARE that doing what you're suggesting is likely to lead to an awful lot of wasted cpu and disk io resources. Yes, you often need stats on the columns used in a WHERE clause, but just doing a blanket process which is what I think you're looking for probably not your best bet. Even if a column is used in a WHERE clause, if collecting stats on that column doesn't change the structur of the explain (by structure I mean order of tables, type of join etc) then collecting stats is a waste of time. You really need to take a more detailed look at your processing.


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: 15 Jun 2023