Re: Chained_Rows
From: <jdorlon_at_my-deja.com>
Date: Fri, 19 Jan 2001 15:26:32 GMT
Message-ID: <949mar$h2s$1_at_nnrp1.deja.com>
Date: Fri, 19 Jan 2001 15:26:32 GMT
Message-ID: <949mar$h2s$1_at_nnrp1.deja.com>
- Analyze table X list chained rows
- Create table Y with the same structure as X
- insert into Y select * from X where rowid in (select head_rowid from chained_rows where table_name = X)
- (verify that the rows are there..)
- delete from x where rowid in (select head_rowid from chained_rows where table_name = X)
- insert into X select * from Y
- (verify that you had the same number of rows as when you started)
- commit
- drop table Y
- think about increasing PCTFREE on table X so you don't get as many
chained rows in the future
- you may have to disable FK constraints and triggers before you move the rows around
There is a low costGUI tool called EZSQL that can do all of this for you with a few mouse clicks. Look under 'tuning' and 'analyze'. www.ezsql.net.
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 19 2001 - 16:26:32 CET