15.00 - General Procedure for Defining a Single-Table Join Index - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

General Procedure for Defining a Single-Table Join Index

1 Define a column_1_name for each column_name in the primary base table to be included in the single-table join index.

2 To enhance join selectivity, define the primary index on a different column set than the primary base table, or define column partitioning with no primary index.

3 If the physical database design warrants, use:

  • CREATE INDEX to create one or more NUSIs on the join index
  • A WHERE clause to define a sparse join index
  • A unique primary index for the join index