15.10 - IndexColumns - 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

Captures the columns that form the index identified by IndexID during index analysis by the Teradata Index Wizard.

The following CREATE TABLE request defines the IndexColumns table.

   CREATE TABLE IndexColumns(
     WorkLoadID       INTEGER NOT NULL,
     RecommendationID INTEGER NOT NULL,
     TableID          BYTE(6) NOT NULL,
     IndexID          INTEGER NOT NULL,
     ColumnName       VARCHAR128 CHARACTER SET UNICODE
                      NOT CASESPECIFIC NOT NULL)
   PRIMARY INDEX ( RecommendationID, TableID, IndexID ); 

The following table defines the IndexColumns table attributes.

 

Attribute

Definition

WorkloadID

Uniquely identifies the workload analyzed to create this secondary index recommendation.

RecommendationID

  • Uniquely identifies the recommendation ID in the IndexRecommendations table.
  • Partial NUPI for the table.
  • TableID

  • Uniquely identifies the table ID in the IndexRecommendations table.
  • Partial NUPI for the table.
  • IndexID

  • Uniquely identifies the index in the IndexRecommendations table.
  • Partial NUPI for the table.
  • ColumnName

    The name of the column in the index.

    The number of rows in IndexColumns for a given index is equal to the number of columns in the index, so any composite index has multiple rows associated with it.