Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 01 Sep 2014 @ 12:56:56 GMT


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


Subj:   Re: Left Join leading to product Join
 
From:   Dieter Noeth

Robert Briggs wrote:

  You do realize that the WHERE clause can't be evaluated until AFTER the outer joins are performed? Your WHERE A11.PRODUCT_GN_NBR = '2874.80469' is only evaluated after all of the outer joins have been completed resulting in an enormous spool file.  


No, that's wrong. If you check Explain you see that the optmizer already applies the filter within the first steps.

There must be some other reason why this query runs out of spool.


Dieter



     
  <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