Re: complex locking and sequence generation

Maxim Demenko wrote:
[...]
> Another idea - if only gapless representation of data is required - one
> can use inserts in a table with reqular sequences ( with all the
> benefits of concurrent processing ) and create a view on this table with
> row_number() over (order by sequence_generated_values) analytical
> function. That is an easy way to eliminate the gaps.
>

This would eliminate 'legitimate' gaps (if such can occur at all), so it's the same as telling the auditors "there are no gaps and even if there are you won't see them anyway".

There is no way to produce gap free sequences without making your database one-threaded/serial for the application that requires such sequences. Received on Mon May 29 2006 - 21:23:36 CDT