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