Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Jul 2006 @ 12:42:35 GMT


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


Subj:   Re: Join Index error
 
From:   Victor Sokovin

As you were looking for an instant hint no testing should be allowed, and I have not tested anything.

Try to add n1.COU_ID, n1.ACC_ID and n1.ACG_ID to the SELECT list:

     CREATE JOIN INDEX DEVNAD_T.ACCOUNT_JI1,
         FALLBACK AS
          SELECT  a1.COU_ID, a1.ACC_ID, a1.ACG_ID, n1.NAD_ID, n1.NAM_NM,
     n1.COU_ID,
     n1.ACC_ID, n1.ACG_ID
         FROM      DEVNAD_T."ACCOUNT" a1 LEFT JOIN DEVNAD_T.NAD n1
         ON               (
              a1.COU_ID = n1.COU_ID AND
              a1.ACC_ID = n1.ACC_ID AND
              a1.ACG_ID = n1.ACG_ID                     )
         PRIMARY INDEX (COU_ID, ACC_ID);

Regards,

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