IndexColumns - Analytics Database - Teradata Vantage

Function of IndexColumns

Captures the columns that form the index identified by IndexID during index analysis using INITIATE INDEX ANALYSIS.

IndexColumns Table Definition

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 );

Attribute Definitions for IndexColumns

The following table defines the IndexColumns table attributes: