Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Jan 2004 @ 15:41:23 GMT


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


Subj:   Re: Collecting Statistics -- Question
 
From:   PThomson2

  "A good compromise, if you are on V2R5, is to use the 'Collect Stats Using Sample' option. "  


Good point when we go to V2R5. Currently are on V2R4.1.3 and will be for a few more months anyway.


  "Otherwise, if this column will always have the same value, you should be able to collect regular statistics just once, and then never collect them again (assuming you collect stats at the column level, and not the table level.)"  


We do collect stats at the table level; but for this particular job, I could probably modify.


Thanks for the suggestion.



     
  <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