Re: Live Reorganize from SQL-script?

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 DBA