Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 08 Jul 2008 @ 20:51:06 GMT


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


Subj:   Re: How to Analyze tables in Teradata?
 
From:   Fred Newbrough

In version 12 it is especially important that you keep stats up to date because if the optimizer determines the stats are stale it will automatically use the random amp sample regardless of existing stats. Also you do not have to collect stats in a linear fashion. You can run multiple stats collections against the same table or multiple tables at the same time which can significantly reduce the amount of time it takes to collect stats.


-Fred



     
  <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