Archives of the TeradataForum
Message Posted: Tue, 27 Apr 2004 @ 08:29:14 GMT
You could develop the idea further for concurrent sessions by introducing some kind of a check out/check in mechanism. For example, define a special flag for each ID column. Every time a session requests the max value it sets the flag to, say, 1 (check out). After the session is done with its work it sets the value back to 0. Flag=0 should be a condition under which any session can ever get the actual max value. I think such a mechanism would not create any performance bottlenecks in your situation (new product IDs).
I don't think you can have any "out of the box" solution for what you are looking for, so if your consider using generated IDs in this context, some work needs to be done anyway.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|