Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Live Reorganize from SQL-script?

Re: Live Reorganize from SQL-script?

From: <grz01_at_spray.se>
Date: 1 May 2005 06:41:21 -0700
Message-ID: <1114954881.456564.4530@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?
Received on Sun May 01 2005 - 08:41:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US