Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 15 Mar 2012 @ 20:55:20 GMT

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

Subj:   Re: Find tables to run collect statistics
From:   Dieter Noeth


  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.  

This one?


  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?  

You can use my query to determine when stats have been collected last time, but there's no easy way to determine this percentage:

- it might be extracted from DBQL

- you might extend your load jobs to calculate it

- upgrade to TD14 :-)

I'm currently implementing a process for huge tables:

collect partition stats -> compare the new row/partition count to the previous one ->

collect stats when difference > x%


  <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: 23 Jun 2019