Re: Live Reorganize from SQL-script?
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 01 May 2005 16:34:42 +0200
Message-ID: <j5q971tiloffmcri769dghmfibd55prnra_at_4ax.com>
Date: Sun, 01 May 2005 16:34:42 +0200
Message-ID: <j5q971tiloffmcri769dghmfibd55prnra_at_4ax.com>
On 1 May 2005 06:41:21 -0700, grz01_at_spray.se wrote:
>Well, even if you dont have fragmentation of extents,
>you may still get e.g. row-migration, from excessive updates,
>tables after deletes will have less dense blocks (requiring more IO
>when read),
>and indexes will usually perform better after rebuilding them, dont
>they?
row migration can be adressed by experimenting with pctused and
pctfree.
That indexes will usually perform better after rebuilding them is a
myth. That it is a myth has been demonstrated here several times.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sun May 01 2005 - 16:34:42 CEST