Re: Live Reorganize from SQL-script?
From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 1 May 2005 18:31:35 +0200
Message-ID: <42750467$0$24164$ba620e4c_at_news.skynet.be>
Date: Sun, 1 May 2005 18:31:35 +0200
Message-ID: <42750467$0$24164$ba620e4c_at_news.skynet.be>
<grz01_at_spray.se> wrote in message
news:1114954881.456564.4530_at_g14g2000cwa.googlegroups.com...
>
> 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?
>
Individual tables can also be rebuild with ALTER TABLE ... MOVE ... Don't forget to rebuild the indexes afterwards (and recompute the optimizer statistics).
Matthias Received on Sun May 01 2005 - 18:31:35 CEST