 |
 |
Archives of the TeradataForum
Message Posted: Thu, 05 Sep 2002 @ 17:22:17 GMT
| Subj: | | Hashing on TimeStamp Column |
| |
| From: | | Tony Howe |
I have a column define as: DT_ROW_UPD TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), which is use as the Unique Primary
index on a table. When loading data to this table it hashes all rows to the same VPROC even though the DT_ROW_UPD is an unique
number, but the only thing different is the micro seconds, where date may be the same and time as far as HHMMSS will be almost the
same. Has does Teradata HASH a timestamp(6)??
| |
