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

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

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.