Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 10 Oct 2006 @ 22:28:07 GMT


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


Subj:   Re: Index columns reversed in SHOW TABLE
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, October 10, 2006 18:18 -->

Never noticed this, but order of columns in INDEX specification logically doesn't matter.

And in fact it won't physically differ either since assigned sequence in the index, i.e. DBC.Indexes.FieldPosition, will actually depend on FieldID and not the order in the DDL.



     
  <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