Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Index Type
From:   David Clough

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.


Dave Clough
Database Designer
Express ICS


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020