> what happens then ? You've got an index thats packed at 100% with
> possibly more PK's coming in. That could be a nasty block splitting
> headache.
>
> --
> Connor McDonald
But if the primary key is populated using a sequence, the chances of
block split are low here. I only think of one situation with cached
sequence and a lot of concurrent inserts on the table. In this case
there may be block splits. But for serial inserts with a sequence block
splits will not happen. Correct me if I am wrong.
Received on Tue Sep 20 2005 - 05:49:41 CDT
