15.10 - Index_Field - 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 all the index columns used in the query plan.

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

The following table defines the Index_Field table attributes.

 

Attribute

Definition

RelationKey

  • Unique identifier for the relation in which the captured index columns are defined.
  • Partial NUPI for the table.
  • Partial USI for the table.
  • IndexNum

  • Unique identifier for the captured index.
  • Partial NUPI for the table.
  • Partial USI for the table.
  • FieldID

  • Unique column identifier within a specific table.
  • Partial USI for the table.