Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Dec 2005 @ 14:52:24 GMT


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


Subj:   Re: Drop Stats before loading data ?
 
From:   Mohommod.Khan

I would not recommend dropping stats just for loading unless some thing really massy happening.... It is always recommended to keep your stats up-to date and most of the cases people collect stats after the load within your batch. If you refresh any table that is being added or changed then collecting stats actually helps is telling the parser details about the data demographics. My rule of thumb is to collect stats on Indices, on your Where clause in your SQL, any JI. I am sure you will hear a broad discussion on Stats from this forum and if you are interested , I will recommend to go over "Teradata Query Optimization" from Partners by the CTO, Teradata. This will tell you all the nuts and bolts that you may find it helpful.


Mohommod



     
  <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