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 -> rebuild vs resize

rebuild vs resize

From: Eddie King <eddie_king_at_email.msn.com>
Date: Tue, 3 Oct 2000 10:12:52 -0400
Message-ID: <OGv5KQULAHA.330@cpmsnbbsa09>

in our Oracle 7 database, I found an index that 50 extents (max ext = 99). would an "alter index xxx rebuild" improve performance more than resizing the index, putting all the current extents into one contigous extent?

thanks,
Eddie Received on Tue Oct 03 2000 - 09:12:52 CDT

Original text of this message

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