Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 06 Feb 2001 @ 21:01:31 GMT

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

Subj:   Re: Collect Stat
From:   Michael Larkins

Hi Sudarsan:

I am not exactly sure of what you are attempting to speed up. However, here is a thought:

The first couple of times that you collect "new" statistics on a table, the AMPs must read every row and take its demographics using a full table scan. However, after you have once collected various column and index statistics, all you need do is issue this command:


It will then read all the rows one time and collect all the statistics. This will great improve performance over recollecting each statistic individually.

Also, in V2R4, you can do COLLECT STAT ON ;

I am not sure this is what you are looking for, but I hope it helps.



  <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