Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2008 @ 17:59:04 GMT


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


Subj:   Re: High confidence in Explain
 
From:   Victor Sokovin

  Can anyone explain to me what "high confidence" really means ?  


To me this only means that the optimizer used the stats. The stats can always be outdated but even if they are brand new the optimizer can still get the counts wrong if it needs to apply conditions which are not easily computable from basic stats. I seldom pay attention to the counts. Only in cases when they are way out compares to my expectations I try to understand what is going on.


Victor



     
  <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