15.10 - LT/ST-J1 Indexed Joins - Teradata Database

Teradata Database SQL Request and Transaction Processing

Teradata Database
Programming Reference
User Guide

In the LT/ST-J1 class index join, some combination of the join columns of the small tables comprises an index of the large table.

This subclass consists of those LT/ST-J1 joins in which the cardinality of the Cartesian product of the small tables is small relative to the cardinality of the large table.

The magnitude of this cardinality difference cannot be defined rigorously; it depends on factors such as the following:

  • Types of indexes defined
  • Conditions used by the old join plan
  • Conditions used by the new join plan
  • Size of the columns retrieved from the small tables
  • This subclass consists of all LT/ST-J1 joins that are not of subclass LT/ST-J1a (Reasonable Indexed Joins).