Archives of the TeradataForum
Message Posted: Wed, 13 Jan 2011 @ 00:16:05 GMT
| Subj: | | Re: Strictly Increasing Identity |
| |
| From: | | Walter, Todd |
Batch size is a system parameter as you suggest. Setting it to 1 will give the semantics you desire but will cause the entire load process to
be single threaded through the ID allocator on a single AMP. This will probably impact performance so negatively that you will not find it
acceptable for any size batches.
The allocations stay active until a restart occurs. So in your scenario, 4 could easily be allocated during the next load. Each AMP starts from
the place it left off in the batch it was allocated when starting a new insert/load process. The intent is to use all of the allocated numbers and
not lose any unless a restart occurs.
| 
