Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 07 Mar 2003 @ 01:25:37 GMT

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

Subj:   Re: The Column order in Primary index
From:   John Hall

I want to correct my last paragraph (I've been painting all day and the can's instructions were right about the fumes ).

The index columns aren't in alphabetical order, but are in the order in which the columns where defined for the table. When a column is defined, a row for that column is placed in table DBC.TVFIELDS and each column for a table is given a sequential FIELDID (starting with the value of 1025, then 1026, etc). When the row(s) are inserted into DBC.INDEXES, they refer to the column by its FIELDID, as defined in DBC.TVFIELDS. So what we're really seeing is that the index columns are listed in FIELDID order.

Sorry about the mistake.

  <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: 28 Jun 2020