|
|
Archives of the TeradataForum
Message Posted: Fri, 11 Apr 2003 @ 19:50:44 GMT
Subj: | | Re: How to implement the sequence concept in Teradata |
|
From: | | Dieter N�th |
Ganga Palakattil wrote:
| For example, if you need to keep a log table (process log), it is a good idea to generate an automatic sequence number to identify
the process. Latest run of the process will have the maximum value for the Sequence Number. | |
Be aware that this is not true in Teradata. From SQL Manual Vol. 4:
"Because the Teradata architecture is highly parallel, generated identity column numbers do not necessarily reflect the
chronological order in which rows are inserted."
Dieter
| |