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 220.127.116.11 and SQL Assistant 7.2.0. Thank you. Regards, Nancy