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