Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Mar 2012 @ 19:46:50 GMT


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


Subj:   Find tables to run collect statistics
 
From:   JAMES PARK

TD 13 on Windows

I posted a question regarding collecting statistics before but would like to bring it up again. I think a user directed me to a website but I couldn't find it.

As I run collect statistics for ALL TABLES(thousands tables both in PRD and DEV) every other week I think it is unnecessary and time and resource consuming especially for those tables that haven't been changed.

Is there a way or a SQL to find tables that have been changed (insert, delete, update) at a certain percent and need collecting statistics?


Thanks,

James Park
Database Specialist II



     
  <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