In a normalized PDM, relation tables are often difficult to query. We have to choose precisely one Primary Index as a query path for direct accesses. The other side of the relationship typically needs a full table scan. Using a Teradata join index can help improve the performance of queries. Below is an example table.

Read More