Re: Adjacent key locking

In article <Cq0L0o.5pB@cix.compulink.co.uk> akent@cix.compulink.co.uk ("Andy Kent") writes: >V6.00-on claim to remove the 'feature' whereby adjacent index entries get >locked. > >Can someone explain *how* this has been achieved? Does it apply in every >case? (ie. insert/ update/ delete) > >akent@cix.compulink.co.uk (Andy Kent) >------------------------------------- >44 272 742815 The reason behind the original design stemmed from problems handling deleted records, especially with rollbacks. In a nutshell, the fix was to add a new discrete byte to the indices to reference a deleted row. These are added the first time that update statistics is run on a newly converted system, or when indexes are created. This byte is scanned during system recovery as well. It applies in every case.