meta_JoinIndexes - 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_JoinIndexes

Returns the current join indexes by system and database in the repository. Corresponds to the SystemHasJoinIndexes relationship.

 

Table 100: Columns and Data Types of the meta_JoinIndexes View  

Column

Data Type

SystemName

VARCHAR(256)

DatabaseName

VARCHAR(128)

JoinIndexName

VARCHAR(128)

IsSynchronized

VARCHAR(6)

LastAlterTimestamp

TIMESTAMP

RequestText

VARCHAR(12500)

CreatorName

VARCHAR(128)

JoinIndexLoid

INTEGER