Index_Field - Teradata Vantage

Function of Index_Field

Captures all the index columns used in the query plan.

Index_Field Table Definition

The following CREATE TABLE request defines the Index_Field table:

CREATE TABLE Index_Field(
  RelationKey  INTEGER NOT NULL,
  IndexNum     INTEGER NOT NULL,
  FieldID      INTEGER NOT NULL)
PRIMARY INDEX PK_Relationkey_IdxNum(RelationKey, IndexNum)
UNIQUE INDEX USK_RelationKey_IdxNum_FieldID (RelationKey,
 IndexNum, FieldID);

Attribute Definitions for Index_Field

The following table defines the Index_Field table attributes: