Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Oct 2005 @ 10:57:42 GMT


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


Subj:   Re: Help on Join Index with Outer Joins, please.
 
From:   cbarrineau

Questions regarding the optimizer's decision not to use your JI:

1) Try creating a NUSI and collecting stats on the Division_Number and Account_Number fields in your JI. Also, for good measure, collect stats on those 2 JI columns individually.

2) Try re-creating the JI without 'compression'...perhaps this is a bug specific to compressed JIs

3) Are the left outer joins necessary or could they (all or partly) be replaced with Inner joins and RI (to maintain flexibility)? In other words, is a one to many relationship between the tables guaranteed by the application? If not, then ignore this 3rd point.


Hope this helps.


Thanks,

Clay



     
  <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