Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Mar 2010 @ 16:23:12 GMT


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


Subj:   Re: Self joins are not allowed in Join Index!!
 
From:   Diehl, Robert

Syed,

We came across the a problem like this several years ago. You can only bring a table into the join index one time. I have not checked to see if this limitation has been removed from newer version of Teradata. In our case the table brought in twice was a reference table. We just made a second copy of the table as it was small with few updates. Add triggers on first table to keep them in sync.

Maybe you can use this method in your case.


Thanks,

Bob Diehl



     
  <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: 23 Jun 2019