Archives of the TeradataForum
Message Posted: Wed, 02 Mar 2005 @ 19:30:07 GMT
Subj: | | Re: DBC.INDEXES and Index Types |
|
From: | | Dieter Noeth |
Anomy Anom wrote:
| I believe I understand what J, P, S stand for but can not find documentation on what the others stand for. | |
Check the Data Dictionary Manual for info about IndexType:
P (Nonpartitioned Primary)
Q (Partitioned Primary)
S (Secondary)
J (join index)
N (hash index)
K (primary key)
U (unique constraint)
V (value ordered secondary)
H (hash ordered ALL covering secondary)
O (valued ordered ALL covering secondary)
I (ordering column of a composite secondary index)
M (Multi-Column Statistics)
1 (field1 column of a join or hash index)
2 (field2 column of a join or hash index)
But...
Forget about dbc.indexes to count Join Indexes, you'll never succeed :-)
It's easy if you use dbc.tables.TableKind instead:
'I' -> Join Index
'N' -> Hash Index
Dieter
|