Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Feb 2004 @ 17:07:26 GMT


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


Subj:   Re: Simple question about a left outer join...
 
From:   Victor Sokovin

Richard,

Thank you for the explain. It looks like it does not take advantage of the "is null" condition on the large table and builds the product join on the full tables, which is something you should avoid by all means. There are a few counts in the explain which I don't understand. For example, how 54,587,480 rows from Step 4 ("estimated with high confidence") relate to the fresh table row count you mentioned (5,461,246). It might be worth reporting this case to your NCR rep, especially if you are using one of the recent releases.

In the meantime you will of course need another solution. Perhaps you could use alternatives suggested by Mirjam and Henry or tell us what your purpose is so that people can generate more ideas, if necessary.


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