meta_JoinIndexIndices - Teradata Meta Data Services

Teradata Meta Data Services User Guide
Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

meta_JoinIndexIndices

Returns the sub-indexes of the current Join indexes by system and database in the repository. Corresponds to the JoinIndexHasIndices relationship.

 

Table 102: Columns, Data Types, and Values of the meta_JoinIndexIndices View  

Column

Data Type

Values

SystemName

VARCHAR(256)

 

DatabaseName

VARCHAR(128)

 

JoinIndexName

VARCHAR(128)

 

IndexName

VARCHAR(128)

 

IndexType

CHAR(1)

 

IndexTypeA

VARCHAR(35)
  • Primary
  • Partition Primary
  • Secondary
  • Join
  • Hash
  • Primary Key
  • Unique Constraint
  • Value ordered secondary
  • Hash ordered ALL secondary
  • Value ordered ALL secondary
  • Ordering column
  • Multi-column statistics
  • Derived column partition statistics
  • Field1 of join
  • Field2 of join
    		•

    IsUnique

    VARCHAR(3)

     

    IndexNumber

    SMALLINT

     

    JoinIndexLoid

    INTEGER

     

    IndexLoid

    INTEGER