Re: Live Reorganize from SQL-script?
Date: Sun, 01 May 2005 16:34:42 +0200
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
>and indexes will usually perform better after rebuilding them, dont
row migration can be adressed by experimenting with pctused and
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