Re: Incrementation in Oracle
From: (wrong string) éguy <vseguy_at_free.fr>
Date: Thu, 30 Nov 2000 11:04:00 GMT
Message-ID: <3A26425D.8FB0CC9A_at_free.fr>
Date: Thu, 30 Nov 2000 11:04:00 GMT
Message-ID: <3A26425D.8FB0CC9A_at_free.fr>
[Quoted] [Quoted] I don't understand why sequence should be created with nocache option ? Doesn't the nocache option accelerate the generation of the sequence ???
Sybrand Bakker wrote:
>
> Sorry to disagree with you.
> If it is really important that surrogate keys (which is what sequences are
> usually applied for) are really continuous the sequence should be created
> with the nocache option.
> Also, IMO, I don't believe the advantage of having no 'holes' outweighs the
> performance decrease (and potential locking problems) not using sequences.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
Received on Thu Nov 30 2000 - 12:04:00 CET