Re: re-numbering pimary-key
From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Wed, 17 Dec 2003 12:26:40 -0600
Message-ID: <3FE09FDF.B2DFEDCD_at_ram.lmtas.lmco.com>
Date: Wed, 17 Dec 2003 12:26:40 -0600
Message-ID: <3FE09FDF.B2DFEDCD_at_ram.lmtas.lmco.com>
So, I am at a lost at how a cache size of 20 was causing my numbers to increment by 20, and then changing it to 0 is incrementing my numbers correctly.
>
>
> By the way the cache size is how many numbers are stored in memory so
> that an IO to disk does not have to be done until the cache is
> exhausted (or flushed). The increment is what determines the number
> by which the sequence values vary from each other.
>
> And Ed will probably tell you this but the alter table command
> includes an option to enable/disable constraints. See the SQL manual.
> This explnation should be in the Concepts manual section on
> constraints.
>
> HTH -- Mark D Powell --
Received on Wed Dec 17 2003 - 19:26:40 CET