Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Aug 2005 @ 07:44:26 GMT


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


Subj:   Re: Subquery in Explain
 
From:   Victor Sokovin

  Subquery is not straight away identified in the explain. You should go by the tables and conditions in the subquery and see how it is being processed by the optimizer. Optimizer tries different ways of processing a subquery depending on the subquery conditions.  


The optimizer might even rewrite the query and turn the subquery into a join or something. There seems to be more and more formal algebra applied to queries with every new release. I wonder if there is any way of digging up that final internally rewritten query.


Regards,

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: 15 Jun 2023