Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 01 May 2003 @ 12:33:56 GMT


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


Subj:   Join Index Issues
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, May 01, 2003 08:28 -->

Hi, we are running VERSION 04.01.03.45 RELEASE V2R.04.01.03.18 and have experienced a join index causing a 3610 error.

The index was comprised of outer joins of 3 small, no more than a few thousand row, reference tables.

The query causing the error was not intended to use the join index....simply a select from one of the constituent reference tables.

The JI was using outer joins, and when changed to inner joins the error was not seen. However, changing the JI to use inner joins is not an option for obvious reasons.

Has anyone else ran into this?



     
  <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: 27 Dec 2016