Archives of the TeradataForum
Message Posted: Thu, 06 Mar 2003 @ 18:16:02 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|