Identity column not allowed in a Join Index

Database
Enthusiast

Identity column not allowed in a Join Index

I have a four table join; two of them have Identity columns as the primary keys and appear in the join conditions. I attempted to add a Join Index to speed up the join and received this error:
"Failure 5784 Illegal usage of Identity Column "
However, I cannot find this restriction in the CREATE JOIN INDEX section of Teradata SQL DDL Reference manual.

I'm using Teradata V2R6.2, ODBC Driver 3.6.0.3 and SQL Assistant 7.2.0.
Thank you.
Regards, Nancy
1 REPLY
Teradata Employee

Re: Identity column not allowed in a Join Index

in my doc SQL reference chapter 3 page 548: An identity column may not be part of any of the following types of index: .... Join index etc