Archives of the TeradataForum

Message Posted: Tue, 05 Apr 2005 @ 14:54:41 GMT

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

Today I was trying to create join indexes which were fairly simple - as seen below - but none of them got created - I don't understand why - why so many restrictions - Any answers!

     create join index j12 as
      sel t1.a,t2.a from t1, t2;
      *** Failure 5464 Error in Join Index DDL, One of the tables
          does not participate in any join or the join type is not
          allowed.

     create join index j12 as
      sel t1.a,t2.a from t1, t2 where t1.a=t2.a;
      *** Failure 5464 Error in Join Index DDL, Ambiguous name
          specified for a join index.

     create join index j12_n as
      sel t1.a as col1,t2.a as col2 from t1 , t2 where col1>col2;
      *** Failure 5464 Error in Join Index DDL, Only satisfiable
          conditions that have constant and/or inequality conditions
          anded to at least      one equality join between columns from
          different tables which are of the same type are allowed in
          the WHERE clause.

     create join index j12_n as
      sel t1.a as col1,t2.a as col2 from t1 right outer join t2 on col1=2;
      *** Failure 5464 Error in Join Index DDL, All selected columns
          of an inner table are nullable.

Table Definition of t1 and t2 are the same:

     Create table t1 (a int, b int);

Narayan

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