Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 20:34:35 GMT


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


Subj:   Re: How good is Explain on a SQL ?
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, April 26, 2006 15:44 -->

Original:

  When I run the Explain on a SQL few steps shows High Confidence and few as no confidence.  


  When and why are the Confidence high, low and No ?  


The confidence level is related to how accurate the estimate of the optimizer process your request. It had to do the freshness of stats on the join condition. This is a cost based optimizer so more relevent stats will enable optimizer to process your query with higher level of confidence in creating the join plan which we extract using explain modifier for review and troubleshooting.


  Why it the Actual run time(30 mins) a lot more then the Estimated time(2 mins) ?  


Depend on the confidence level of the explain for that estimate, it could be more or less than what was estimated. If the estimate was to process 1000 records and actual process required 1000,000,000 record processing then the time it take will deviate greatly. You can use PMON to see the processing explain and SQL while the query is active on the system to get better understanding of how the system is processing your queries.



     
  <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