Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: chained rows

Re: chained rows

From: <steveee_ca_at_my-deja.com>
Date: Fri, 19 Jan 2001 13:37:29 GMT
Message-ID: <949fup$b1o$1@nnrp1.deja.com>

Hi,

Chained rows occur when a row is physically stored in more than one data block. If you insert a row for instance that is bigger than your oracle block size you have chaining. It affects performance because oracle has to look in more than one place for the data.

S

In article <949d44$8m4$1_at_nnrp1.deja.com>,   letokai_at_my-deja.com wrote:
> What are chained rows?
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 19 2001 - 07:37:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US