Archives of the TeradataForum

Message Posted: Fri, 22 Jul 2011 @ 15:34:18 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Primary Index Column

From:		Mankala, Mahesh

Within DBC.INDEXES, the field INDEXTYPES has the following options:

     J--> Join index
     K--> Primary Key
     N--> Hash Index
     P--> Non Partitioned Primary
     Q--> Partitioned Primary
     S--> Secondary
     V--> value ordered
     U--> Unique Constraint
     H--> Hash ordered All covering secondary
     O--> Value ordered all covering secondary
     I--> ordering column of a composite secondary index
     1--> field1 column of a join or hash index
     2--> field2 column of a join or hash index

Thanks,

Mahesh Mankala