[email]thiscoxharleysvillegroup.com[/email] (Tom Hiscox) wrote in message news:<ec597d5a.0307080749.3d782fbposting.google.c om>...If you have a heavy-hitting transaction application, is it possible> I have an identity column created as 'GENERATED BY DEFAULT' 'NO CACHE'
> 'START WITH 1' 'INCREMENT BY 1'. My problem is that at times it skips
> 1000 entries in the numbering scheme. Any suggestions will help.
that transactions are getting rolled back and it just gives the
appearance of skipping?
For example, Txn 1 inserts a row with an ID of 1. Concurrently, Txn 2
inserts a row with an ID of 2. For whatever reason Txn 1 gets rolled
back but Txn 2 gets committed. So looking at the table it appears
that 1 was skipped. If this happened on a much larger scale it could
appear that larger intervals were being skipped.