meta_HashIndexIndices - 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_HashIndexIndices

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

 

Table 94: Columns, Data Types, and Values of the meta_HashIndexIndices View  

Column

Data Type

Values

SystemName

VARCHAR(256)

 

DatabaseName

VARCHAR(128)

 

HashIndexName

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 hash
  • Field2 of hash
    		•

    IsUnique

    VARCHAR(3)

     

    IndexNumber

    SMALLINT

     

    HashIndexLoid

    INTEGER

     

    IndexLoid

    INTEGER