Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 28 Apr 2003 @ 20:56:33 GMT

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

Subj:   Re: Collect statistics..
From:   Doug

You might consider writing a script to determine if statistics even need to be collected and then dynamiclly generating the collect statistics statement on the fly.

I've done it different ways depending on the customers requirments. On my last project, we collected stats after large changes as well as dynamically collecting them in scheduled windows.

The V2R5 Statistics Wizard is a pretty cool tool to figure out what columns need stats and generate the statements. Teradata manager also comes with a manual Statistics Collection tool that you can use on the fly.

God Luck...


  <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