Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 11 Apr 2014 @ 19:34:10 GMT


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


Subj:   Running Statistics
 
From:   JAMES PARK

1) I read an article of someone who recommends running Statistics on join columns and index columns and columns used in WHERE statements.

Since I don't know what columns users are going to use in WHERE clauses, is it a good idea to run statistics on all columns of all tables? I am mainly concerned about queries running in PRD and QA.


2) I run two batch jobs update statistics once every two weeks. The two scripts have all Collect Statistic statements; one for DEV and the other PRD.

I wonder how you update statistics regularly.

We have TD 14 system. Our database servers are in Suse 11 but BAR server is on Windows XP.


Thanks,

James Park
Database Specialist



     
  <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