Re: Chained Rows VS new extent allocation

> Chaining occurs when rows are updated and become too large to fit into a
> block.

Chaining occurs when a row is too large to fit into any block and the row must be spread among more than one block to hold the data. When a row is updated and becomes to large to fit into its current block, then it is *migrated*.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"