Join Index Class Property Descriptions - 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

Join Index Class Property Descriptions

 

Table 51: JoinIndex Properties 

Property Name

Description

CommentString

The comment stored in Teradata for the join index

CreatorName

Name of the Teradata user that created the join index

DatabaseID

Teradata assigned identifier for the database where the join index resides

JoinIndexID

Teradata assigned identifier for the join index

LastAlterTimeStamp

Time that Teradata last updated the object

PartitioningUsed

If the join index has a PPI, contains PPI, or else is set null

RequestText

The CREATE JOIN INDEX statement that created the join index

SynchronizationLevel

Internal Flag

0 = Invalid references detected
1 = all information complete
-2 = QuickLoaded join index