Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2003 @ 18:16:02 GMT

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

Subj:   Re: The Column order in Primary index
From:   Chuck McDevitt

The primary index of a table is not a separate structure like a secondary index.

Instead, the primary index determines which columns are hashed to decide both what AMP the row goes on and what order the rows are stored in.

Since the "data" for the primary index is the row itself, the columns are by definition in the order they were defined in the table.

Teradata could "remember" what order you said on the primary index clause, but there isn't any reason to do so, since it doesn't affect how the data is actually stored.

  <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: 27 Dec 2016