Archives of the TeradataForum
Message Posted: Fri, 09 Dec 2005 @ 12:34:40 GMT
Can anyone tell me what the difference is between types 'O' and 'V' is, as well as the difference between 'S' and 'H' from the statement below, which is derived from dbc.Indices:
CASE IndexType WHEN 'S' THEN 'Secondary' WHEN 'U' THEN 'Unique Constraint' WHEN 'V' THEN 'Value Ordered' WHEN 'J' THEN 'Join Index' WHEN 'N' THEN 'Hash Index' WHEN 'O' THEN 'Value Order (All)' WHEN 'H' THEN 'Secondary (All)' ELSE IndexType END (TITLE 'Type')
Basically I want to highlight any Join Indexes or any type of secondary index on a specified table, but I'm unclear what the 'O's and 'H's are.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|