Cardinality and Uniqueness Statistics for the Reasonable Indexed Join Examples - Teradata Vantage

Small Table Cardinality Statistics

For all LT/ST-J1a (Reasonable Indexed Joins) examples, the following row information is given for the small dimension tables:

Large Table Uniqueness Statistics

The following statistics information is given for the large fact table:

Test Query

These examples explain the join plans and estimated time for execution of the following query, when different types of indexes (primary index, unique secondary index, nonunique secondary index) are created on the join columns (color, size, and options) of the large table.

   SELECT …
   WHERE widgets.color = color.code
   AND   widgets.size = size.code
   AND   widgets.options = options.code;