Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 14:03:07 GMT


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


Subj:   On Join Index Creation
 
From:   Narayan Murthy K S

Hi all,

I have a question on join index :

I have two table t1,t2 with the following definition :

CREATE t1( a INTEGER, b INTEGER)PRIMARY INDEX ( a );

and

CREATE t2( a INTEGER, b INTEGER)PRIMARY INDEX ( a );

Now i try creating a join index with the following defintion, why does it fail, what is ambiguous in the definition, i thought the ambiguity of a column could be avoided by qualifying it with a table name, which removes the ambiguity:

create join index ji
as sel (t1.a,t2.b),(t1.b,t2.a) from t1,t2
where t1.a = t2.a;

*** Failure 5464 Error in Join Index DDL, Ambiguous name specified for a join index.


Thanks

Narayan Murthy K S



     
  <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