Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 12 Mar 2003 @ 20:13:29 GMT


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


Subj:   Re: Stats on the PI
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, March 12, 2003 15:09 -->

Hi,

Collecting stat on small table very helpful why?

Ans.

when Teradata join one small table with very big, The optimizer copy one of the table on all Amps. By collecting statistics on small tables Teradata server now which table to copy. So Teradata pick small table.

it is not necessary you only collect statistics on small tables. you can collect statistics all indexes Primary plus secondary after every 10% data change in tables

Thanks



     
  <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