Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 14:54:25 GMT

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

Since you haven't specified a Primary Index, Teradata is probably defaulting the first column ('t1.a') of your select statement as the Primary Index. Teradata cannot create a primary index for a column name which is prefixed by a table tablename; therefore, you will need to create an alias for 't1.a' and then reference that alias in the definition of your primary index.

For example:

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

Something to consider. The above JI format is intended for compressed Join Indexes. You might want to consider a non-compressed Join index definition. For example;

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

Hope this helps!

Claybourne Barrineau

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