Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 08 Dec 2009 @ 15:59:22 GMT


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


Subj:   Re: Theoretical collection over collecting stats
 
From:   Fred W Pluebell

Collecting statistics does not make individual retrieval steps (or very simple queries) any faster.

Statistics only allow the optimizer to more accurately determine the costs for alternative join methods, retrieval methods, and execution sequences. That can make complex queries run faster, because a different access plan may be chosen.



     
  <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