Archives of the TeradataForum

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

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

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>>