I am new to teradata and I am trying to create a outer join index. I am getting an error as mentioned below. I have given all columns in the outer table in the SQL still getting this error
[Teradata Database]  Error in Join Index DDL, Outer table field is not in the SELECT list.
Eventually i gave the query, Still getting the same error. We are having a slow performance query (with spool error) thats why i thought of creating one index.
It will be great help if to get any solution.
You would have to include fl.JoinKey (join column from the outer table) in the SELECT list, along with a "NOT NULL" column from fn (the inner table).