Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 16 Feb 2001 @ 19:53:57 GMT

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

Subj:   Re: Collect Stat
From:   Steve Bracewell

What really works well is automating this entire process. We run an automated process that uses a 'cycle' table to determine which of our non-fastloaded tables are due for collected stats (as determined by demographic change frequency and 'last date collected'). The process then queries DBC tables to produce collect stats statements for 'stale' single and multi column nupi and upi indexes. The 'cycle' table is managed by dbc.tables, alleviating the possibility of a table being introduced without making it to our 'cycle' table. This, along with our other administrative processes we've automated, leaves us time to do really cool things.

/TeraMont boys

  <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: 28 Jun 2020