Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 25 Sep 2014 @ 22:42:06 GMT


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


Subj:   Re: Same query - Different Explains
 
From:   frank.c.martinez

Of course the EXPLAIN varies by the table counts. An extreme example is the difference between an empty table and one that has data in it. They vary also because the optimizer might consider a table a "small" table in one situation and a large table in another. Why do you think there are statistics, and what do you think they contain? I suggest a basic class in the way the optimizer works would be of assistance.


iv



     
  <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