17.10 - Index_Field - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
B035-1142-171K
Language
English (United States)

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:

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.