|
Archives of the TeradataForumMessage Posted: Wed, 21 Nov 2007 @ 12:54:14 GMT
I seem to recall that Join Indices were defined with IndexTypes of 1 or 2 (back in the day). Is my recall correct? If yes what did/do ?1? and ?2? mean. Are these IndexTypes still in use from aged data structures? The summary list of Indextypes from prior notes is below. From the TD Data Dictionary Manual: Returns the type of an index as: * 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) Thanks, Bill Gregg
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||