Archives of the TeradataForum

Message Posted: Fri, 09 Dec 2005 @ 12:34:40 GMT

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

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.

Thanks.

_______________________
Dave Clough
Database Designer
Express ICS

www.tnt.com

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