Re: Please define ROW CHAINING!!!
From: Johnnie Suggs <jes_at_usa.pipeline.com>
Date: 1995/10/01
Message-ID: <44l4ov$p5_at_news1.usa.pipeline.com>#1/1
Date: 1995/10/01
Message-ID: <44l4ov$p5_at_news1.usa.pipeline.com>#1/1
Nabil Courdy (ncourdy_at_parka.winternet.com) wrote:
: I am teaching myself -trying to at least- Oraclle. I monitor this
: newsgroup as one of my resources. Could someone please tell me
: what Row Chaining is?
row chaining is...
when a row can not fit into a single block. it is then chained across multiple blocks. the initial row piece remains in the block where the row was first targeted. each additional row fits into a chained block. performance degradation will occur. to see any chained rows...
analyze table "table" list chained rows
-- Johnnie S.Received on Sun Oct 01 1995 - 00:00:00 CET