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 -> Indexes space use

Indexes space use

From: ThierryHuge <ThierryHuge_at_france-mail.com>
Date: Fri, 21 Aug 1998 11:16:15 +0200
Message-ID: <35DD3ADE.24FDC4C5@france-mail.com> 





I have a table T which have an index I


Users run a lot of insert/delete operations on T (then on I)
Each time the key is different. It seems the blocks allocated for I are
not reused.


Table T has always a few number of lines but I have a lot of extents
allocated for I.



Could someone explain how space is allocated for the index when a lot of
insert/delete are run onto the corresponding table ?

Received on Fri Aug 21 1998 - 04:16:15 CDT












Original text of this message













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