Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Mar 2002 @ 23:19:07 GMT


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


Subj:   Re: Collect Stats on large table
 
From:   Thomas A. Fastner

Pauline,

you definitely need statistics on large tables. This will enable 'with high confidence' decisions of the optimizer and come up with the most effective access plan. In case the optimizer is missing statistics a random sample will be taken and due to the size of the table (unless the data are skewed) the optimizer will provide basically the same statistical information, but makes his decision with a lower confidence level.

If the data don't change much, like having a three year detail table and adding daily or weekly data, you should be fine for a while. In this case there is no need to refresh the statistics weekly; probably every 6 month would be enough. (The recommendation might change in V2R5 with PPI)

The note in the documentation looks to me like a left over from previous releases, when the optimizer was less sensitive and sophisticated.

Best regards,

Tom Fastner
Consultant
Teradata Certified Master
Teradata
A Division of NCR



     
  <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: 15 Jun 2023