Re: Inserts and row chaining

From: Ian Wilkins <ianw_at_sensible.teleord.co.uk>
Date: 1997/01/14
Message-ID: <5bg26f$rnq@sensible.teleord.co.uk>#1/1

In article <5bebm7$gvi_at_news1.ee.net>, Unknown <zgeist_at_ee.ee.net> wrote:
>However, I would think that just inserting bytes until PCTFREE was
>reached (and then continuing in another block) would result in a ton of
>chained rows. What am I missing ?

Um, I think it does check if a row fits in first. If we leave LONGs and RAWs out of the arguement for a minute. If I remember correctly when inserting rows you never get chained rows. As the solution to chained rows caused by updates is to copy them out of the original table, delete, then insert them back in. If the insert caused chained rows, then this solution wouldn't work.

Ian. Received on Tue Jan 14 1997 - 00:00:00 CST