Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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.

Thanks.


_______________________
Dave Clough
Database Designer
Express ICS

www.tnt.com



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