Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Apr 2008 @ 10:46:21 GMT


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


Subj:   Re: COLLECT STATISTICS on Indexed Columns &
 
From:   Gaitonde, Amol A

Please collect stats and see if there is any difference in optimizer plan, not just cardinality estimates, but in join operation types as well. If it doesn't make any difference and if there are no skewed values, you may ignore.

If you are using TASM as are regulating the priorities and aborting queries using TASM on the basis of Join confidence, it may be useful to collect, even if the join types and cardinalities are near same before and after collecting.


Thanks.



     
  <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