Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Feb 2002 @ 11:29:59 GMT


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


Subj:   optimiser query
 
From:   Martin O Brien

Hi,

Have people had experience with the optimiser choosing different access paths when using the inner join syntax rather than joining in the where clause?

We have had experience when joining our transaction table to 2 smaller tables

- when joining in the where clause the transaction table is accessed via a nested loop join using a NUSI

- when joining using the inner join syntax the transaction table is redistributed and product joined .

As a very small subset of the transaction table is to be joined the query performs much better going the nested loop join method.


Regards,

Martin O'Brien



     
  <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