Archives of the TeradataForum
Message Posted: Wed, 02 Mar 2005 @ 18:05:50 GMT
Subj: | | DBC.INDEXES and Index Types |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, March 02, 2005 13:08 -->
I am trying to write a query that gives me a list of all join and hash indexes we have on our system. At the present time I am querying from
dbc.indexes and was looking at the IndexType. When I do a distinct on this column I get the following results:
J
K
M
P
Q
S
V
I believe I understand what J, P, S stand for but can not find documentation on what the others stand for.
Thanks for any help
|