15.10 - LT-ST-J2 Unindexed Joins - Teradata Database

Teradata Database SQL Request and Transaction Processing

Teradata Database
Programming Reference
User Guide

In the LT/ST-J2 class unindexed join, no combination of the join columns of the small tables comprises any index of the large table.

This subclass consists of those LT/ST-J2 joins in which the cardinality of the Cartesian product of the small tables is much smaller than the cardinality of the large table.

The difference between the cardinalities of the small tables Cartesian product and the cardinality of the large table is much larger for LT/ST-J2a joins than for LT/ST-J1a joins, though it cannot be defined rigorously.

This subclass consists of all LT/ST-J2 joins that are not of subclass LT/ST-J2a.