Re: Avoiding any locks in SQL Servers - read and understand....its magic.

ctcgag_at_hotmail.com wrote

> > This still sounds like fantasy to me. Worse, data needs to be
> > "reconstructed". This smacks of unneeded complexity and probable data
> > corruption when the reconstruction gets it knickers in a knot.
>
> Er, does that objection also apply to Oracle's rollback/undo logic?

No. There's a big difference in attempting to determine from multiple non-locking simultanous transactions how the final image should look like, versus a before/after image approach.

--
Billy