Archives of the TeradataForum

Message Posted: Wed, 11 Oct 2006 @ 09:36:33 GMT


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

Subj:		Re: Index columns reversed in SHOW TABLE

From:		Victor Sokovin

I created a table using the following ddl. If I do a show table (shown in the second create below), the order of the column in the index is reversed. Has anyone ever seen this before?

Hashing is commutative in Teradata so the column order displayed in the DDL does not really matter:

     select HASHROW ('A', 'B');

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     HASHROW('A','B')
     ----------------
     51180436

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     select HASHROW ('B','A');
     select HASHROW ('B','A');

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     HASHROW('B','A')
     ----------------
     51180436

Regards,

Victor