We are currently deploying a new user interface and navigational structure on our Community. These design changes align with our new Teradata Access portal and provide a more cohesive experience for our users.
At what situation or condition PE decide to take the data from the JOIN INDEX or from the normal join.
If your sql is covering sql. ie all columns needed to process the query are present in the existing index.
If a query refers to only columns that are part of the index, Teradata would decide to read the Index subtable rather than looking up the base table